Forum Discussion
JChouris
Helper I
Helper IColor Coding Specific data in a Matrix.
I have a matrix and need certain things to come with a color background. I am fairly new to BI and conditional formatting is not my strong suit. Any help would be greatly appreciated. Example. ESC sh...
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.
JChourisHelper I
Helper IHere is a sample of the table i draw these specs from.
| Resets | Reset ID | Description |
| ESC | 1 | Electronic Stability Control - Optional Feature - Reset Required if present. Use OEM scan tool (No Codelink Support Yet) |
| ESC* | 2 | Electronic Stability Control - Reset Required - Standard Feature. Use OEM scan tool (No CL Support Yet) |
| ESC► | 3 | Electronic Stability Control - Optional Feature - Reset Required if present. Use CodeLink or OEM scan tool |
| ESC→ | 4 | Electronic Stability Control - Reset Required - Standard Feature. Use CodeLink or OEM scan tool |
| EPS | 5 | Electronic Power Steering - Optional Feature - Reset Required if present. Use OEM scan tool (No Codelink Support Yet) |
| EPS* | 6 | Electronic Power Steering - Reset Required - Standard Feature. Use OEM scan tool (No CL Support Yet) |
| EPS► | 7 | Electronic Power Steering - Optional Feature - Reset Required if present. Use CodeLink or OEM scan tool |
| EPS→ | 8 | Electronic Power Steering - Reset Required - Standard Feature. Use CodeLink or OEM scan tool |
| ACC | 9 | Adaptice Cruise Control - Optional Feature - Reset Required if present. Use OEM scan tool (No Codelink Support Yet) |
| ACC* | 10 | Adaptice Cruise Control - Reset Required - Standard Feature. Use OEM scan tool (No CL Support Yet) |
| ACC► | 11 | Adaptice Cruise Control - Optional Feature - Reset Required if present. Use CodeLink or OEM scan tool |
| ACC→ | 12 | Adaptice Cruise Control - Reset Required - Standard Feature. Use CodeLink or OEM scan tool |
| AEB | 13 | Automatic Emergency Braking - Optional Feature - Reset Required if present. Use OEM scan tool (No Codelink Support Yet) |
| AEB* | 14 | Automatic Emergency Braking - Reset Required - Standard Feature. Use OEM scan tool (No CL Support Yet) |
| AEB► | 15 | Automatic Emergency Braking - Optional Feature - Reset Required if present. Use CodeLink or OEM scan tool |
| AEB→ | 16 | Automatic Emergency Braking - Reset Required - Standard Feature. Use CodeLink or OEM scan tool |
| EPS³ | 17 | Electronic Power Steering - Reset Required - Standard Feature Use CodeLink or OEM Scan Tool |
| EPS³☼ | 18 | Electronic Power Steering - Reset Required - Standard Feature Use CodeLink or OEM Scan Tool (Requires CodeLink OEM expansion cable) |
| EPS³► | 19 | Electronic Power Steering - Reset Required - Standard Feature Use CodeLink or OEM Scan Tool |
| EPS³☼ | 20 | Electronic Power Steering - Reset Required - Standard Feature. Use CodeLink or OEM scan tool |