topic Re: Dynamic Chart Title based on Level of Hierarchy being displayed in DAX Commands and Tips

Dynamic Chart Title based on Level of Hierarchy being displayed

Carmichael01 — Mon, 13 Jul 2020 00:01:53 GMT

I would like to esentailly 're-create' the way a chart title changes when you move up and down a hierarchy as per the following;

https://dataandai.files.wordpress.com/2019/05/drill-up-and-down-title-change.gif?w=533&zoom=2

However, the automiatically generated title is too on so I want to shoten it bu keep the dynamic reference to the level of the hierarchy. I initally tried ISINSCOPE and HASONEFILTER but these done work as expected - as per here

I want to use in both maps as well as the curtom bullet chart visual. The main aim is when the user is reading the report they can tell at which level they have drilled up/down.

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

lbendlin — Sun, 12 Jul 2020 18:13:41 GMT

"Don't work as expected" - please elaborate?

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

Carmichael01 — Mon, 13 Jul 2020 00:10:28 GMT

Apologies - I have updated the inital post where I hadnt posted the correct link to another thread that describes the same issue.

Here is is again:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Position-in-drill-down-hierarchy-of-a-visual-in-the-absence-of/td-p/745026

The expected behaviour I am looking to acheive is the same as the native/standard Power BI title which changes to display the level of the hierarchy depending on where the user is (drill up and down).

ISINSCOPE only shows the level when it is used certain visuals /visual elelments. It works in a table as each row context can be applied but it doesnt do the same in measure for the title.

HASONEFILTER only works if there is a filter applied which isn the case when using drill up/down in the hierachy.

In summary - the best way to reframe the question is "How do I recreate the native/standard BI title in a measure so that it references the level of the hierarchy being displayed/used in the visual?"

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

lbendlin — Mon, 13 Jul 2020 00:37:23 GMT

Your statement on ISINSCOPE

"ISINSCOPE only shows the level when it is used certain visuals /visual elelments. It works in a table as each row context can be applied but it doesnt do the same in measure for the title."

is not what the doumentation says. https://docs.microsoft.com/en-us/dax/isinscope-function-dax

You should be able to use that function for your measure text computation.

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

lbendlin — Mon, 13 Jul 2020 00:53:32 GMT

I see your point. The matrix title is wired to Measure 4. Interestingly enough the filter context for the individual items works correctly. It's the Totals that throw things off. But this should be manageable.

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

Carmichael01 — Mon, 13 Jul 2020 01:50:00 GMT

Thanks for looking at this.

I think that your current measure is just pickng up the ELSE statement "Fiscal Month" so if there is NO SCOPE (none on the title) then it just returns that value as there is no context for the title to work with. I also beleive that the ISINSCOPE order needs to be from lowest level to highest of the hierarchy.

I quickly created the example you used.

ISINSCOPE = VAR _inscope = SWITCH( TRUE(), ISINSCOPE('Date Table'[Fiscal Month]), "Fiscal Month", ISINSCOPE('Date Table'[Fiscal Quarter]), "Fiscal Quarter", ISINSCOPE('Date Table'[Fiscal Year]), "Fiscal Year", "No Scope" ) RETURN _inscope

I think this is even more evident when you change this into a visual rather than a table. The ISINSCOPE works as a tool tip (becuase it has context) but the title will always be No Scope

TBH I am not even sure I was on the right track using ISINSCOPE...

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

Carmichael01 — Tue, 14 Jul 2020 00:42:00 GMT

Just trying to bump this.... anyone got any ideas?

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

Anonymous — Mon, 31 Aug 2020 21:13:28 GMT

Having the same issue.

ISINSCOPE works if you drill down on a matrix for example or in the tooltip, but if you use a measure to dynamically show the level you are on the visual title, it does not seem to work.

Any idea why?

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

craigdormire — Fri, 06 May 2022 21:33:58 GMT

Would still like to find a solution to this - Chart Title display current hierarchy level. Works as Tool Tip, not for Chart Title. Thanks for any tips!!

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

Anonymous — Mon, 12 Sep 2022 13:44:37 GMT

Hi, I am facing a similar issue. Have you found any good solution for this?

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

biki — Fri, 10 Feb 2023 14:25:10 GMT

hi,

me too just want to apply this dynamic title based on hierarchy level, is there any new solution for this?

please advice, thanks!

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

Staverton_Ben — Wed, 13 Dec 2023 09:56:51 GMT

Also required! Thanks for any intel

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

gatzkm — Sat, 09 Nov 2024 16:30:35 GMT

I am trying to change the title to indicate if it is by year, quarter or month for line graph. Does any one have a solution? Tried ISINSCOPE but did not work, please advise!

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

gatzkm — Sat, 09 Nov 2024 16:32:19 GMT

Did you figure this out? I am having the same issue, tried ISINSCOPE and did not work:

Re: Dynamic Chart Title based on Level of Hierarchy being displayed

EOW — Wed, 07 May 2025 09:39:28 GMT

If anyone is still hoping for a solution to this, I've submitted it as an idea on the Ideas forum:
Let a visual title and Axes read displayed hierarc... - Microsoft Fabric Community
Hopefully it gets traction.