Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filtering depending on continent location

In our business customer city and counrty is storing in DataBase, that we can visualize in the report using map, by using the power bi logic is it possible to filter depending on the continent, there is no filed to describe the continent in DB , How to achieve this by using the power bi logic. 

Need Help
Show and Tell

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    You will need a continent column in your data to get the filter against Continent.

    If there is no such column in the data,

    • Create an additional mapping table with City and Continent in it.
    • Then relate this new table on CITY column with your main table on CITY column in Power BI.
    • Use CONTINENT column as a filter

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      But in the case of refreshing the data how it will take automatically which continent.