Forum Discussion
Conditional Formatting Based On Field Rules Not Working
The results are not matching conditional formatting rules. Why?
Hi diogobraga2 ,
See my top picture, save your rule as decimals, and use number. I forget why this works this way, but there is a reason. Something to do with percentage meaning a percentage of all your values.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
5 Replies
Hi diogobraga2 ,
See my top picture, save your rule as decimals, and use number. I forget why this works this way, but there is a reason. Something to do with percentage meaning a percentage of all your values.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
NathanielIt worked, thanks! Now, how do I make the same conditonal formatting apply to the total???
Hello diogobraga2 ,
You are welcome!
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formattingSee below
Considerations and limitationsThere are a few considerations to keep in mind when working with conditional table formatting:
- Conditional formatting is applied only to the values of a Matrix visual, and does not apply to any subtotals or grand totals.
- Conditional formatting is not applied to the Total row.
- Any Table that does not have a grouping is displayed as a single row that doesn't support conditional formatting.
- If you use gradient format with automatic max/min values or rule-based formatting with percentage rules, conditional formatting cannot be applied when your data contains NaN values. NaN means 'Not a number', most commonly caused by a divide by zero error. You can use the DIVIDE() DAX function to avoid these errors.
