cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors