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
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/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
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
ColumnFree
Visualizing Surplus and Deficit Using Stacked Column Chart
This article presents an alternative method for visualizing actual performance against target values.
29 September 20257 min read
ColumnFree
Visualizing MoM Change with the Piano Chart
This article provides a step-by-step guide to replicating the “Piano” or “Delta” chart, a creative visualization for showing changes between two points in time, within Power BI.
29 September 20254 min read
Matrix/TableFree
Implementing Proper and Optimized Pagination
For the improved version, please refer to the following documentation page:
29 September 202511 min read
ColumnMember-Only
Visualizing Stock Price Trends with Candlestick Charts
The DAX measures used here have been improved and modified for better readability and performance. </Callout>
29 September 20255 min read