Switch columns on a Map

[SHTELVIS]

Hi 

I Have the following requeriment is that when an ACCOUNT NAME has only one country  A map should display STATE for example DHL USA is only in USA and has STATE information the map should display STATE  and When the country has more than one country in this example COCA COLA has more than 1 country show in the map COUNTRY , and the data set example is shown in the picture. 

What will be the approach to do it with out using drilldown ? users find it hard to use or don't even it exist  

Thans in advance for your help 

[SHTELVIS]

Hi @Idrissshatila  

This is just a sample data with 3 companies, but the real has more than 10000 companies worldwide so it has changed dynamically 

Any idea ? 

Thanks for your Answer 

[SHTELVIS]

Hi @Idrissshatila  

Thanks for your quick response, it works you are right but is there a way to do it without creating a slicer and the user needs to click there's no way to do it automatically ?. 

When there's just one country for a desired company to do the zoom-in and show State?

[Idrissshatila]

@SHTELVIS , 

you could combine the two columns into one by creating a calculated column as the following and use it in the map:

County/state = if( 'yourTableName'[COUNTRY]= "UNITED STATES OF AMERICA", 'yourTableName'[STATE], 'yourTableName'[COUNTRY])

[Idrissshatila]

Hello @SHTELVIS ,

check the field parameters concept and see if you want it like this.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters