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