Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
diogobraga2
Helper IV
Helper IV

Conditional Formatting Based On Field Rules Not Working

The results are not matching conditional formatting rules. Why?

 

2019-11-26_1555.png

1 ACCEPTED SOLUTION
Nathaniel_C
Super User
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
cc2.PNG

 

cc.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
rleseberg
Frequent Visitor

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

Nathaniel_C
Super User
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
cc2.PNG

 

cc.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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. 

 

2019-11-26_1801.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.