ColumnMember-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.
LineFree
Dynamically Displaying Earliest, Latest, and Growth Over Time with a Year Slicer
This documentation provides a guide on marking the earliest and latest selected years on a line chart and visualizing growth over time with reference lines.
26 October 202511 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
LineFree
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
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
Matrix/TableMember-Only
Dynamically Show Top N and Others Based On Metric Selection
I’ve previously discussed creating Pareto dashboards to help you identify your “vital few” and “trivial many” customers.
26 October 202532 min read