LineFree
Integrating a Dynamic Slope Graph Within a Line Chart
This article demonstrates how to build a Power BI line chart that dynamically highlights a selected year range while greying out the rest.
31 January 202619 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.
LineFree
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
LineFree
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
LineFree
Dynamically Displaying Earliest, Latest, and Growth Over Time with a Year Slicer
This documentation provides a guide on marking the earliest and latest selected years on a line chart and visualizing growth over time with reference lines.
26 October 202511 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
LineFree
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
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