Forum Discussion
Color Measures For Incidents
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.
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 🙂
6 Replies
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 🙂
