Conditional format on matrix table

Cheng2202 

To achieve conditional formatting based on multiple conditions and comparison between two columns in a matrix table in Power BI, you can follow these steps:

1. **Create Conditional Formatting Measure**:
Create a measure that calculates the color based on your conditions. You can use DAX expressions to evaluate the conditions and return the appropriate color code. Here's an example measure:

```DAX
Conditional Format =
VAR Totalt = SELECTEDVALUE('YourTable'[Totalt])
VAR Budsjett = SELECTEDVALUE('YourTable'[Budsjett])
VAR PercentOfBudsjett = Totalt / Budsjett
RETURN
SWITCH(
TRUE(),
Totalt = 0, "Red",
AND(PercentOfBudsjett > 0, PercentOfBudsjett <= 0.1), "Yellow",
PercentOfBudsjett > 0.1, "Green",
BLANK()
)
```

Replace `'YourTable'`, `'Totalt'`, and `'Budsjett'` with your actual table name and column names.

2. **Apply Conditional Formatting**:
Go to the conditional formatting settings for the "Totalt" column in your matrix table. Choose "Icon Sets" as the formatting type. Then, use the measure you created above as the field to base the icons on.

3. **Configure Icon Rules**:
Set up three icon rules corresponding to your conditions:
- Red: Rule where the measure equals "Red".
- Yellow: Rule where the measure equals "Yellow".
- Green: Rule where the measure equals "Green".

4. **Ensure Icons Only on "Totalt"**:
Make sure the conditional formatting is applied only to the "Totalt" values and not the "Budsjett" values. You can adjust the conditional formatting settings to target only the "Totalt" column.

By following these steps, you should be able to apply conditional formatting with icons based on multiple conditions and comparison between two columns in your matrix table in Power BI. Adjust the measure and rules as needed to fit your specific requirements.


Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!