The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
@markmess77 - You might consider disabling the title all together and just use a Card visual.
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 @Greg_Deckler My issue can be shown from this blog post:
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.
@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.