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.
Matrix/TableFree
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
30 December 202542 min read
Matrix/TableFree
Maintaining Visual Alignment in Matrix-Chart Combinations
This documentation will walk you through the process of creating a combined visualization using a matrix and bar/column charts, ensuring they remain visually aligned regardless of…
26 October 20257 min read
Matrix/TableFree
Integrating Custom Sorting Slicers with Paginated Table
This documentation details advanced pagination techniques, extending my previous tutorial and documentation.
26 October 202512 min read
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
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