Forum Discussion

sachecka's avatar
sachecka
Regular Visitor
7 years ago

Drilldown in Map visualisation for Bermuda

Hi

I have state and country information for US, Canada and Bermuda. 

Power BI is able to recognize and drill down from country to state for US and Canada. But not Bermuda. 

For Bermuda I would like to see parishes like St.George's, Paget, Smiths etc.

How to know the valid inputs for the state information for Bermuda?

Please help me.

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi sachecka ,

    By my tests, we could drilldown from country to state for Bermuda.

    Please check if your have the correct state or province for the state column of Bermuda.

    More details, please refer to my attachment.

    If you still need help, please share your sample data so that we could help further on it.

    Best Regards,

    Cherry

     

    • sachecka's avatar
      sachecka
      Regular Visitor
      7 years ago

      Hi 

       

      I couldn't find Hamiltonas, Bermuda when tried to google search it. Hamilton, Bermuda is the right name. 

       

      Is there a way to find the accepted names by Bing? 

       

      Also, Bermuda has parishes rather thatn state or provinces and my dataset has the following:

      St.George's

      Pembroke

      Paget

      Devonshire

      Sandys

      Warwick

      I would like to see these... 

      Please let me know how to get these showing up on the map.

      Thanks

      SChecka