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
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.
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
Donut/PieFree
Creating Dynamic IBCS-Standard Pie Charts (Updated Version)
RETURN SWITCH( SelectedMetricOrder, -- Transaction Metrics 0, "Total Transactions", -- Revenue Metrics 1, "Total Revenue",
26 October 202514 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
Matrix/TableFree
Implementing Proper and Optimized Pagination
For the improved version, please refer to the following documentation page:
29 September 202511 min read
Metric/KPIFree
Applying RFM Analysis for Customer Segmentation
This documentation guides you on how to perform RFM analysis for customer segmentation in Power BI.
29 September 202511 min read