Forum Discussion

GrimReaperX's avatar
GrimReaperX
Helper II
2 years ago
Solved

Conditional formatting on Shape Map

Hello,    I would like to manage colors on the Shape Map based on certain conditions. I have projects and statuses low, medium and high. I would like to show high risk projects red, medium risk pro...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, GrimReaperX 

     

    You can try the following methods.

    Measure = SWITCH(TRUE(),
SELECTEDVALUE('Table'[Risk Level])="High","Red",
SELECTEDVALUE('Table'[Risk Level])="Medium","Blue",
SELECTEDVALUE('Table'[Risk Level])="Low","Green")

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

GrimReaperX's avatar
GrimReaperX
Helper II
2 years ago

Hello,

 

Thanks for the reply. However, my table shows the same color for all of the countries. I have different table for countries and different table for Risk level. I also use custom map but not predefined maps. Could you please help? 

 

Thanks!

v-zhangti's avatar
v-zhangti
Community Support
2 years ago

Hi, GrimReaperX 

 

Can you provide sample data for testing? Sensitive information can be removed in advance. And give an example of the output you expect.

 

Best Regards