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
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
Scatter PlotMember-Only
Interactive Scatter Plot: Dynamically Switch Dimensions and X/Y Metrics
This interactive scatter plot is designed to empower users to interactively explore relationships between different dimensions and metrics. Key features include:
26 October 202510 min read
LineFree
Creating Dynamic Slope Graph with △PY% Label
A slope graph is a type of line chart that shows changes between two points in time or two different states.
29 September 20254 min read
LineFree
Building a Vertical Lollipop and Dumbbell Charts
This article demonstrates how to create a dynamic vertical lollipop and dumbbell chart in Power BI.
29 September 20253 min read
LineFree
Highlighting Specific Values in a Line/Area Chart
This article will guide you through the process of visually emphasizing key data points within a line chart.
29 September 202511 min read
BarFree
Visualizing Variance Alongside Bar Chart
This article demonstrates how to create additional lollipop charts alongside bar charts to visualize year-over-year variance, a technique inspired by Bas Dohmen.
29 September 20255 min read