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.
Helper IThis is the database i draw from. Each Reset needs a color coding. Just unsure how to conditional format these as they are not numerical values. I need them to show up colored
Super UserPlease provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523