Forum Discussion

brlimagu's avatar
brlimagu
Frequent Visitor
8 years ago

Filled map issue

I have a column that has a bunch of country codes and I have created a calculated column to "transform" this codes into the country name (see below) doing so I could use Filled map to fill the countr...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi brlimagu,

 

Since you only have country code, creating a new column of country name is essential. Switch function is good. 

 

If you want to group many country into a big region, you can add a conditional column, then add it to the legend.

1. Add a conditional column. It's Zone in my example.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2. Create a measure for the color saturation like this:

ColorValues =
CALCULATE ( SUM ( 'Table1'[Value] ); ALLEXCEPT ( Table1; 'Table1'[Zone] ) )

3. You can see there are three colors and the value of each country of each zone is the same respective. So the color would be the same.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale