dynamically changing the title on drilldown in pie chart

[smeg]

Hi ,

 I am looking for some help  to dynamically change the title based on drill down level in below pie chart.If I drill up it is at channel level so I need title as "Actual Gross Rev by Channel" ,if i drilldown one level it needs to be retiitled as "Actual Gross Rev by Acct Plan" .But with the below measure I am using every time it is shown as "Actual Gross Rev by Acct Plan".

Dynamic Title = IF(SELECTEDVALUE('Fact_NPI'[Channel]),"Actual Gross Rev by Channel","Actual Gross Rev by Acct Plan")

Can some one please help to fix this?

Thanks..

[kushanNa]

Hi @smeg 

try this dax mesure as title? 

Dynamic Title = 
IF(
    HASONEFILTER('Table'[Channel]),
    "Actual Gross Rev by Acct Plan",
    "Actual Gross Rev by Channel"
)

or this 

Dynamic Title = 
IF(
    HASONEFILTER('Table'[Channel]),
    SELECTEDVALUE('Table'[Channel]) & " - Actual Gross Rev by Acct Plan",
    "Actual Gross Rev by Channel"
)

[v-aatheeque]

Hi @smeg ,

If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

We value your feedback, and it will help us to assist others who might have a similar query.

Thank you for your contribution in enhancing Microsoft Fabric Community Forum.

[v-aatheeque]

Hi @smeg ,

If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.

[Ritaf1983 · Accepted solution]

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

[kushanNa]

Hi @smeg 

If you are looking to change of the title based on the hierachy down arrow then this workaround could work for you . 

https://community.fabric.microsoft.com/t5/Desktop/Dynamic-title-using-hierarchy/m-p/3146675#M1063493 

[maruthisp]

Hi smeg,

Please try below DAX expression and let me know if that works or need any changes.

Dynamic Title =
SWITCH(
TRUE(),
ISINSCOPE('Fact_NPI'[Acct Plan]), "Actual Gross Rev by Acct Plan",
ISINSCOPE('Fact_NPI'[Channel]), "Actual Gross Rev by Channel",
"Actual Gross Rev"
)

Please let me know if you have further questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X