Conditional Formatting Based On Field Rules Not Working

[diogobraga2]

The results are not matching conditional formatting rules. Why?

[Anonymous]

Thank you. The decimal switch fixed my map as well.

[Nathaniel_C · Accepted solution]

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

[diogobraga2]

It worked, thanks! Now, how do I make the same conditonal formatting apply to the total???

[Nathaniel_C]

Hello @diogobraga2 ,
You are welcome! 
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting 

See below

Considerations and limitations

There 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.

[diogobraga2]

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.