Knowledge Drop

Why is my Conditional Formatting ignoring values?

  • 6 April 2021
  • 0 replies

Last tested: Aug 23, 2019

If this is a percent calculation, first check if the percent formatting is applied to a decimal value. Conditional formatting applies to the raw values, so if the formatting is applied on the front end, try changing the conditional formatting rule value to decimal format (ex: 0.7 instead of 70%). See Why isn't my Conditional Formatting rule applying to my Percent values in table visuals/table calculations? for more detail.

If formatting the formatting rule is defined correctly, check if "Limit Displayed Rows" is enabled.

Screen Shot 2019-08-23 at 8.49.38 AM.png

Currently, conditionally formatting is applying formatting to the order of rows in the returned data, not the visualization. When rows are hidden from the visualization, this causes a misalignment and it looks like the conditional formatting is not correctly applying the rules.


This content is subject to limited support.                



0 replies

Be the first to reply!