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.

v-zhangti's avatar
v-zhangti
Community Support
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