Forum Discussion
Switch columns on a Map
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
4 Replies
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
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?
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])
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
