Forum Discussion
Solved
Dynamic Title with hierarki
Hello, Can anyone help me! I have a slice with hieareki location ( City--> Zone) . I want to create a dynamic title to the graph. When I choose All in slice it will show " USA" i the titel. W...
Hi,
Dynamic Title =
VAR SelectedZone = VALUES('Table'[Zone])
VAR SelectedCity = VALUES('Table'[City])
VAR SelectedCountry = SELECTEDVALUE('Table'[Country])RETURN
SWITCH(
TRUE(),ISFILTERED('Table'[Zone]),
CONCATENATEX(SelectedZone, 'Table'[Zone], ", "),ISFILTERED('Table'[City]),
CONCATENATEX(SelectedCity, 'Table'[City], ", "),SelectedCountry
)
To apply:
Go to Title -> Conditional Formatting (Fx)Choose Format by "Field Value" and select measure "Dynamic Title" that we created.
Let me know if that helps!
Dynamic Title =
SWITCH(
TRUE(),
HASONEVALUE(Location[Zone]), "USA - " & SELECTEDVALUE(Location[Zone]),
HASONEVALUE(Location[City]), "USA - " & SELECTEDVALUE(Location[City]),
"USA"
)
If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande