Forum Discussion
Helper IColor Coding Specific data in a Matrix.
Hi JChouris ,
According to your description, here's my solution, create a measure.
Color = SWITCH ( MAX ( 'Table'[Resets] ), "ESC", "Gray", "ACC", "Blue" )In the visual formatting pane>Visual>Cell elements, turn on the Backgroud color option, and select fx button.
Select the color measure in the field.
Ge the correct result.
More information about conditional formatting, you can refer to this documnet:
Apply conditional table formatting in Power BI - Power BI | Microsoft Docs
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserEasiest would be to create a reference table with each Reset value and the color name of the color you want to assign to that Reset. Tie that table into the data model and then use the color field for the formatting - use any aggregation your want, for example max([color])
