WaterfallMember-Only
Columns with Horizontal Waterfall Chart (Version 2)
You can find my explanation of the IBCS horizontal waterfall chart's construction logic in Power BI on LinkedIn:
28 October 202515 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
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
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
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
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
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
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
Matrix/TableMember-Only
Creating a Dynamic Pareto Dashboard (Third Version)
RETURN SWITCH( SelectedVariableOrder, -- When Customer dimension is selected (Order = 0) 0, CALCULATE( [03 Dynamic Selected Metric], ALLSELECTED('DimCustomer') ), -- When Product…
26 October 202516 min read