Why is my Conditional Formatting ignoring values?

Knowledge Drop

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

Version history
Last update:
‎04-05-2021 03:15 PM
Updated by: