BarMember-Only
Bars with Vertical Waterfall Chart (Version 2)
A Vertical Waterfall Chart is a way to clearly show why two numbers are different by breaking down the changes that happened in between.
23 November 202568 min read
Every pattern, indexed by the problem it fixes
Documented Power BI techniques — the model change, the DAX, and the exact visual settings. Most are free to read; the rest come with the model files for members.
BarFree
Dynamic Highlighting and Key Message Integration
Field parameters are a powerful feature in Power BI. When combined with the SWITCH() function, these tools allow us to tell a compelling data story by dynamically highlighting…
10 November 202535 min read
BarFree
Building Tornado (Butterfly) Chart
This documentation will guide you how to create tornado chart, also known as tornado diagram or butterfly chart, in Power BI using entirely native visuals.
26 October 20255 min read
BarFree
Integrating Custom Sorting Slicers with Paginated Table
This documentation details advanced pagination techniques, extending my previous tutorial and documentation.
26 October 202512 min read
Metric/KPIFree
Creating a Dynamic Customer Pareto Dashboard (First Version)
This documentation provides a step-by-step approach to building the first version of the one-for-all customer Pareto analysis dashboard.
26 October 202517 min read
Metric/KPIFree
Creating a Dynamic Customer Pareto Dashboard (Second Version)
Imagine you have a big pile of something – let's say, 100 colorful building blocks.
26 October 202517 min read
Metric/KPIFree
Turning KPI/Metric Cards Into Interactive Slicers
In the world of Power BI, Key Performance Indicator (KPI) and metric cards are essential.
26 October 202516 min read
BarFree
Visualizing Variances with Error Bars Dynamically
RETURN SWITCH( SelectedMetric, "Total Transactions", "Total Transactions by Sub-Category", "Total Revenue", "Total Revenue by Sub-Category", "Total Quantity", "Total Quantity by…
26 October 202516 min read
Donut/PieFree
Creating Dynamic IBCS-Standard Pie Charts (Updated Version)
RETURN SWITCH( SelectedMetricOrder, -- Transaction Metrics 0, "Total Transactions", -- Revenue Metrics 1, "Total Revenue",
26 October 202514 min read