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 🙂
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.
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 🙂