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
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.
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
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
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
BarFree
Visualizing Variances with Error Bars Dynamically
RETURN SWITCH( SelectedMetric, "Total Transactions", "Total Transactions by Sub-Category", "Total Revenue", "Total Revenue by Sub-Category", "Total Quantity", "Total Quantity by…
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