LineMember-Only
Small Multiples to Show Daily Trends Across Many Categories (Part 1)
Show one metric’s daily trend, one small chart per category, all on the same scale.
12 July 202610 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
Integrating a Dynamic Slope Graph Within a Line Chart
This article demonstrates how to build a Power BI line chart that dynamically highlights a selected year range while greying out the rest.
31 January 202619 min read
LineFree
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
LineFree
Columns with Horizontal Waterfall Chart (Version 1)
A waterfall chart is a special type of bar chart that shows you the story behind how a number changed from one point to another.
28 October 202552 min read
LineMember-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
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
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