Color Measures For Incidents

[nosirui54]

I had been having this problem for about two days. Am really banging my head now, please i need some help.

Please how do I create Color Measures for these Incidents:

• Critical  - (Red)
• High    -   (Light Red)
• Low       -  (Blue)
• Medium  - (Light Blue)
• Very Low - (Grey)

Like I want any incident reported as critical to be Red, while High incidents to be Light Red and so on.

[nosirui54]

@TheoC Just tried it again. it works. Thanks

[TheoC · Accepted solution]

Hi @nosirui54 

You can use a conditional statement such as the following:

Background Colour = 

     SWITCH ( 
          SELECTED VALUE ( 'table'[column] ),
              "Critical" , "Red" ,
              "High" , "Light Red" ,
              "Low" , "Blue" ,
              "Medium" , "Light Blue" ,
              "Very Low" , "Grey" , 
              "White" )

You can change the "white" to whatever but it represents the "false" in what if none of the conditionals are true.  

You can also change the colours to specific colours you want by adding the "FF0000" for red, etc., etc.

Hope this helps 🙂

[nosirui54]

@TheoC Thank you so much for saving me from this headache. I truly appreciate it. 
Please is there a way to show only colors in the background, maybe in another column without showing Incident name with the background color? Have tried some method but is not just working.

[TheoC]

Hi @nosirui54,

You should be able to replicate the process and apply it to the Font colour the same way you have for the Background colour 🙂 I tested it out and it works perfectly 🙂

[nosirui54]

@TheoC I tried the process but is not working, i guess it works as shown above because you use black background. I'll leave it as its for now. 

Thank you for time. 

[TheoC]

Hi @nosirui54 I used black and white background and black and white font.  The output hides the font because the font is the identical colour to the background.  If you are using different colours, I recommend using something like this site so that you can pick the exact colour you want for the background and the font instead of using "red" "blue" etc etc: https://www.rapidtables.com/web/color/RGB_Color.html

By picking the exact colour code, you will have confidence that the font and the background will match perfectly. 

Hope this helps mate 🙂