Dynamic Map Title with Drilldown

[maxmnb]

Hi,

I have a map visual with 3 levels of data (State, County, and City). I want to display which level of the hierarchy I am currently in and changes as you drill up or down in the visual. I have been able to figure out how to display a selected value from a slicer but can't figure it out for drilling down in a map visual.

Any idea how I can display which level I am currently on while drilling down?

Note: If there is a way to use buttons or a slicer to make the map drill up and down that would also work.

Thanks so much!

[v-cgao-msft]

Hi @maxmnb ,

Please use similar conditional formatting on map visual.

Measure = "Now at " & SELECTEDVALUE(DimGeography[Country]) & " Country " & SELECTEDVALUE(DimGeography[State]) & " State " & SELECTEDVALUE(DimGeography[City]) & " Ctiy"

See if it helps.

Power BI Desktop April 2019 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

Attached PBIX file for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[maxmnb · Accepted solution]

Hi, 

Thanks for the suggestion. The SELECTEDVALUE function didn't work because the text needed to be conditional on the drilldown within the map instead of clicking a slicer. I was able to resolve the issue by creating a bookmark for each data layer in the map's drilldown and then also having a text box that said which level was clicked. That way when you click a bookmark, it would drilldown/up to a specific layer and the textbox for that layer would appear.