Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Dyanmically changing the title based on the drill down

Hi   How to change the title in a chart with drill down feature to show the bread crumbs of the drill down. Say I have drilled down from year to quarter. Then the title should show Year-2016 Quart...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Let's take a scenario where the hierarchy is:
Level1(Top of the hierarchy. In your case, Year)
Level2(Month)
And so.
 
The DAX to create a dynamic label while drilling down on any chart would be:
Selected Value = IF(ISBLANK(SELECTEDVALUE('Table'[Level1])), "Default label", IF(ISBLANK(SELECTEDVALUE('Table'[Level2])), SELECTEDVALUE('Table'[Level1]),SELECTEDVALUE('Table'[Level2])))