Forum Discussion
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 Quarter Q1.
Cheers
9 Replies
I haven't seen anything to suggest Microsoft have addressed this one yet.
I agree that although cosmetic this one iis actually pretty fundamental. I've had lots of business feedbackdemanding this context, and it really is analysis presentation 101 that charts/graphs should have a title (without which bars/funnels/charts have no clear reference point). My kids would be lose marks for not including a chart title in maths homework.
Unfortunatley this is one of the reasons that using Power BI (along with inability to drill down correctly on published dashboards among others) with management here is still a risk to analysts' credibility.
Adding this feature (even by means of a standard breadcrumb trail) would certainly improve the chances of business adoption.
I haven't seen anything to suggest Microsoft have addressed this one yet.
I agree that although cosmetic this one iis actually pretty fundamental. I've had lots of business feedbackdemanding this context, and it really is analysis presentation 101 that charts/graphs should have a title (without which bars/funnels/charts have no clear reference point). My kids would be lose marks for not including a chart title in maths homework.
Unfortunatley this is one of the reasons that using Power BI (along with inability to drill down correctly on published dashboards among others) with management here is still a risk to analysts' credibility.
Adding this feature (even by means of a standard breadcrumb trail) would certainly improve the chances of business adoption.
- 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])))
You create a measure that returns text. The measure detects the state of various filters and concatenates various peices of text accordingly. Will Thompson shows how at about 28 minute mark of this youtube video.
https://www.youtube.com/watch?v=d2bZpNZ6uIA
Hey Brian_M, the video only shows once a filter has been clicked and applied across the page. What Anonymous appears to be referring to is when you drill down to another level of the hierarchy. So in this case, the hierarchy would be Year -> Quarter and it would be in one visualization. I tried tinkering with this and I can't seem to get the value out of the filter, I'll see what else I can find out.
Ah, I missed that!
I wonder whether you could write DAX to detect the drill down, perhaps you could detect the Year context disappears altogether?
Sorry, forgot to mention. You turn off the exisitng title and place a text measure in a single item card above the chart to act as the dynamically generated title.
I created this Idea ... help up-vote it!
