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.
BarFree
Report Redesign with IBCS (Case Study 1)
This section focuses on using the core IBCS principles to redesign (makeover) various public company reports.
8 December 202538 min read
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
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
BarFree
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
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
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