WaterfallMember-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.
WaterfallMember-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
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
WaterfallFree
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
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
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
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
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
LineFree
Creating Dynamic Slope Graph with △PY% Label
A slope graph is a type of line chart that shows changes between two points in time or two different states.
29 September 20254 min read