Forum Discussion
Dynamic title using hierarchy
Hi igrandey89 ,
Thank you for your suggestion. I tried your measure, and adjusted a few things. However, it didn't work (Only "Default Title" became visible).
I created a workaround:I placed a button with a bookmark on the expanding one level in the hierarchy-arrow. So when the user clicks on this, it just redirects you to another chart with a manual title. I placed a button and bookmark on this chart too, to be able to go back.
I have been searching for a while, and I noticed that more people had this issue which weren't solved. So I guess using a dynamic title by clicking on the expanding one level in the hierarchy isn't possible (yet)
To make the dynamic title change when expanding the hierarchy instead of only when drilling down, you can use the HASONEVALUE function along with SELECTEDVALUE. Here's a modified version of your DAX measure that should work:
Dynamic title2 =
VAR CurrentLevel =
SWITCH (
TRUE (),
HASONEVALUE ( Calendar[DayOfWeekName] ), 1,
HASONEVALUE ( Calendar[Weeknumber] ), 2,
0
)
RETURN
SWITCH (
CurrentLevel,
1, "Number of alarms per day and week",
2, "Number of alarms per week",
"Default Title"
)In this measure, we first create a variable CurrentLevel to identify the current hierarchy level by checking whether the user has drilled down or expanded on the DayOfWeekName or Weeknumber. Then, we return the title based on the value of CurrentLevel.
This should update the title as you expand the hierarchy. However, depending on your data model and how your visualizations are set up, you might need to adjust this code to fit your specific case.
Hi igrandey89 ,
Thank you for your suggestion. I tried your measure, and adjusted a few things. However, it didn't work (Only "Default Title" became visible).
I created a workaround:I placed a button with a bookmark on the expanding one level in the hierarchy-arrow. So when the user clicks on this, it just redirects you to another chart with a manual title. I placed a button and bookmark on this chart too, to be able to go back.
I have been searching for a while, and I noticed that more people had this issue which weren't solved. So I guess using a dynamic title by clicking on the expanding one level in the hierarchy isn't possible (yet)
If it's not already submitted in the PBI Ideas site--I would suggest you do so! https://ideas.powerbi.com/