Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
markmess77
Resolver I
Resolver I

Dynamic titles in hierarchy visual

I'm trying to set up dynamic titles in my hierarchy visual. My primary goal was to dynamically change the title when the visual is drilled down. I was able to do this easily with a dax expression like

Hierarchy Title = 
"Total by "
    & SELECTEDVALUE ( 'Table'[Category], "Category" )

This works perfectly fine, with one exception. 

When the double down arrow is selected to go to the next level in the hierarchy, I want the title to change to 'Total by Subcategory' instead of it staying static. The conditional formatting of the measure above seemed to have lost that functionality. 

I've been trying to manipulate my dax expression to accomplish this, but have yet to find something that works. 

Is there a way I can supplement my conditional formatting to also change when the double arrow is selected?

1 ACCEPTED SOLUTION

@markmess77 - You might consider disabling the title all together and just use a Card visual.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
DataHero
Helper I
Helper I

Is there no DAX solution for this?
There has to be one, otherwise how does Power BI do this for the automaticly generated title?

amitchandak
Super User
Super User

@markmess77 , refer if this can help

https://medium.com/@patilpoojaif/dynamic-title-in-power-bi-164903723c68

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak @Greg_Deckler My issue can be shown from this blog post:

https://data-marc.com/2019/05/05/dynamic-object-titles-in-power-bi/#:~:text=Dynamic%20visual%20title...

 

Under the paragraph, Dynamically change titles using a hierarchy, it shows and describes what I am experiencing. 

It shows how the title changes dynamically when drilling up and going down to the next level in the hierarchy. But it also states that the functionality does not work when the title has been changed. In my case, the conditional formatting measure seems disable that functionality. 

I've been trying to find some clever way around it, but haven't been able to find anything that works.

@markmess77 - You might consider disabling the title all together and just use a Card visual.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Community Champion
Community Champion

@markmess77 - This may help - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...

 

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors