Filtering depending on continent location

[Ramees_123]

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. 

[Pragati11]

Hi @Ramees_123 ,

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

[Ramees_123]

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