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.
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
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
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
Matrix/TableMember-Only
Several Methods to Display Applied Filters
Inspired by Gustaw Dudek's work on displaying applied filters, I have developed two versions of a filter-display solution.
26 October 202537 min read