Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Maps - color saturation based on customised regions

Hi Guys,     I would like to create a shape map where colour saturation depends on the value for the customised region.   I have downloaded a shape map of the world and connected it to my data v...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous

 

For your requirement, you need to add a REGION column in your dataset. Then create a measure to calculate the 'Units Delta' group on REGION:

 

Region Total Units Delta=CALCULATE(SUM(Table[Units Delta]),ALLEXCEPT(Table,Table[REGION]))

Now you can put above measure into color saturation.

 

 

Regards,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-sihou-msft,

 

Thank you for your reply. I have tried exactly that and neverthless didn't get the desired result.

 

GTMU Delta regional = CALCULATE(sum(Query1[GSales Units]),ALLEXCEPT(Query1,Query1[RegionKey]))-CALCULATE(sum(Query1[Previous GSales Units]),ALLEXCEPT(Query1,Query1[RegionKey]))

After I add the measure above to the Color Saturation field, without the Region as Legend it just colors all countries the same, after I add Region to Legend, regions are colored differently, but irrespective of the regional delta value.

 

 

Could you please let me know where do you think is the issue with my approach?

 

Thank you,

Agnieszka