Scatter PlotFree
Dynamic Storytelling Using Scatterplots
Scatterplots can tell very different stories depending on the perspective we choose to highlight.
4 February 202667 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
Dynamic RFM Customer Segmentation
This documentation explains how to perform RFM analysis in Power BI using a dynamic, time-aware approach.
18 January 202650 min read
BarMember-Only
P&L Statement Visualization with Calculation Waterfall and Variance Charts (Cumulative Version 1.0)
This documentation details the enhancements made to the previous visualization version. These updates focus on global scaling logic and cumulative data representation.
16 January 2026166 min read
BarMember-Only
P&L Statement Visualization with Calculation Waterfall and Variance Charts (Non-Cumulative Version)
Vertical waterfall charts (also called bar waterfalls) show you why a value changed between two different points. They are read from top to bottom and consist of three main parts:
14 January 2026105 min read
30 December 202542 min read
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
BarMember-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
Matrix/TableMember-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