Forum Discussion
Conditional Formatting/Coloring Values
Hello all! I have created a matrix and a table on the same tab of a Power BI Report. (See 1st picture below) The table on the left uses conditional columns which I manually inserted into t...
I'm sort of confused a little on this. So do I create a DAX Expression using both the 15 Staff and 5 Staff?
SWITCH(TRUE()
[15 Staff] < #, "Red",
[5 Staff] > #. "Green",
ELSE "Yellow"
Anonymous , You can create a color measure based on the condition that should return color and that you can use in conditional formatting using field values
example
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)
I'm sort of confused a little on this. So do I create a DAX Expression using both the 15 Staff and 5 Staff?
SWITCH(TRUE()
[15 Staff] < #, "Red",
[5 Staff] > #. "Green",
ELSE "Yellow"