Matrix/TableFree
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.
Matrix/TableFree
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
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
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
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
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