Forum Discussion
Conditional Formatting Based On Field Rules Not Working
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
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
It 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.
Thanks for sharing, are you aware of any workarounds or tricks to fix this? The total in this dataset represents schools, and I need to find a way to flag it as well.