Forum Discussion
Conditional Formatting Not Working with Percentage > 100
I am trying to set a rule on a measure if the value is greater than 100% to turn the background color to green.
It its a legitimate number going greater than 100% but I am getting an Logic error.
Can this be fixed /any workaround. Kindly suggest.
Don't use 'Percent' in the drop down, use > 1 'Number' and < 1000 'Number'
The Percent option does not have anything to do with acual percentage values. It looks the the percentag of the total dataset that falls into the range.
1 Reply
Don't use 'Percent' in the drop down, use > 1 'Number' and < 1000 'Number'
The Percent option does not have anything to do with acual percentage values. It looks the the percentag of the total dataset that falls into the range.