Forum Discussion
paul_jones
3 years agoFrequent Visitor
Conditional Formatting with multiple conditions
I have the matrix below, basically: Device Error Message Attempts Errors Percentage Blue1 Did not start 100 50 ...
- 3 years ago
Hi paul_jones ,
The best way for conditional color is:
ConditionalColor = SWITCH ( TRUE (), SELECTEDVALUE ( 'Table'[Error Message] ) = "Did not start" && SELECTEDVALUE ( 'Table'[Percentage] ) = 0.5, "#HexColorcode", SELECTEDVALUE ( 'Table'[Error Message] ) = "Interrupted" && SELECTEDVALUE ( 'Table'[Percentage] ) = 0.3, "#HexColorcode" )If you want to use your second table,you can use CROSSJOIN as well.
But I did not get the logic. This table is a range?
Btw, Measure above would solve your problem.
It helped? Mark it as an accepted solution.
Regards,
Loran
paul_jones
3 years agoFrequent Visitor
I will give that a try. Thank you.