Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Map Title with Drilldown

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!

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.