30 December 202542 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.
Matrix/TableMember-Only
Dynamic Vertical Variance Waterfall Chart (Version 1)
When using a waterfall chart, visual direction determines its purpose: Vertical charts break down data by categories or factors (non-time series), while Horizontal charts track…
21 November 202549 min read
Matrix/TableFree
Maintaining Visual Alignment in Matrix-Chart Combinations
This documentation will walk you through the process of creating a combined visualization using a matrix and bar/column charts, ensuring they remain visually aligned regardless of…
26 October 20257 min read
Matrix/TableFree
Integrating Custom Sorting Slicers with Paginated Table
This documentation details advanced pagination techniques, extending my previous tutorial and documentation.
26 October 202512 min read
Matrix/TableFree
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
Matrix/TableFree
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
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
Scatter PlotMember-Only
Interactive Scatter Plot: Dynamically Switch Dimensions and X/Y Metrics
This interactive scatter plot is designed to empower users to interactively explore relationships between different dimensions and metrics. Key features include:
26 October 202510 min read