topic Re: Dyanmically changing the title based on the drill down in Developer

Dyanmically changing the title based on the drill down

Anonymous — Thu, 05 May 2016 03:58:26 GMT

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

Re: Dyanmically changing the title based on the drill down

Brian_M — Mon, 09 May 2016 16:48:13 GMT

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

Re: Dyanmically changing the title based on the drill down

Brian_M — Mon, 09 May 2016 16:49:16 GMT

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.

Re: Dyanmically changing the title based on the drill down

wonga — Mon, 09 May 2016 18:17:00 GMT

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.

Re: Dyanmically changing the title based on the drill down

Brian_M — Tue, 10 May 2016 09:16:47 GMT

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?

Re: Dyanmically changing the title based on the drill down

wonga — Wed, 11 May 2016 18:02:49 GMT

Yeah I'm not sure if that's possible. What's interesting is if you enable drill down and click on a visual, under "visual filter" it says that it's been applied. However, clicking on a visual without drill down enabled doesn't add a "filter" to any of the filter levels on the right side pane (visual, page or report).

If clicking on a part of visual changes everything else on a page, you would think that's a "page" filter, albeit a temporary one as once you click out of the visual, the filter should be removed.

Just a couple of other thoughts is all...

Re: Dyanmically changing the title based on the drill down

GCoulson — Tue, 02 Aug 2016 07:55:24 GMT

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.

Re: Dyanmically changing the title based on the drill down

GCoulson — Tue, 02 Aug 2016 07:57:35 GMT

I haven't seen anything to suggest Microsoft have addressed this one yet.

Adding this feature (even by means of a standard breadcrumb trail) would certainly improve the chances of business adoption.

Re: Dyanmically changing the title based on the drill down

hymieho — Tue, 11 Oct 2016 21:11:26 GMT

I created this Idea ... help up-vote it!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16609003-detect-drilldown-drill-down-level-to-support-cha

Re: Dyanmically changing the title based on the drill down

Anonymous — Thu, 14 Nov 2019 20:22:55 GMT

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])))