cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper IV

## Conditional Formatting Based On Field Rules Not Working

The results are not matching conditional formatting rules. Why?

1 ACCEPTED SOLUTION
Super User

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

Proud to be a Super User!

5 REPLIES 5
Frequent Visitor

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

Super User

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

Proud to be a Super User!

Helper IV

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

Super User

## See belowConsiderations 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.

Proud to be a Super User!

Helper IV

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.