Forum Discussion
dynamically changing the title on drilldown in pie chart
- 1 year ago
Hi smeg
Unfortunately, there’s no way to dynamically change a visual title using DAX based on drill-down level. The engine behind Power BI visuals doesn’t expose that internal hierarchy state when you click the "fork" icon to drill.
However, you can manipulate the display names of the fields inside the hierarchy itself, which are reflected in the default visual title (see screenshot). Rename the fields in your hierarchy to match the titles you want to show at each level, like:
On a side note – a pie chart is not suitable for comparing values across a hierarchy. Our brain doesn’t process curved angles well, especially when comparing slices or drilling between levels. It gets cognitively overwhelming and less informative.
I highly recommend switching to a bar or matrix visual with hierarchy support, which will:
-
Show actual rankings clearly
-
Enable intuitive comparisons
-
Let users easily expand/collapse levels
All in a way that’s easier for the human brain to process.
The pbix with the example is attahed
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
Hi smeg
Unfortunately, there’s no way to dynamically change a visual title using DAX based on drill-down level. The engine behind Power BI visuals doesn’t expose that internal hierarchy state when you click the "fork" icon to drill.
However, you can manipulate the display names of the fields inside the hierarchy itself, which are reflected in the default visual title (see screenshot). Rename the fields in your hierarchy to match the titles you want to show at each level, like:
On a side note – a pie chart is not suitable for comparing values across a hierarchy. Our brain doesn’t process curved angles well, especially when comparing slices or drilling between levels. It gets cognitively overwhelming and less informative.
I highly recommend switching to a bar or matrix visual with hierarchy support, which will:
-
Show actual rankings clearly
-
Enable intuitive comparisons
-
Let users easily expand/collapse levels
All in a way that’s easier for the human brain to process.
The pbix with the example is attahed
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly