Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sam Duval]

I have a measure that i created that returns a percentage, I apply a conditional formatting on it to put a “flag” on the record if its greater than 50%. It works fine when applied as a whole, but if I filter the table at all. The record gets flagged as “True” under the conditional formatting rule, even though the calculated value is well under the 50% threshold. 

any ideas how to remedy?

——————————
Sam Duval
Data Quality Analyst
Indianapolis
——————————

[colin mcilwain]

Hi
Are you using ‘percent’ in the conditional formatting rather than ‘number’? If so, try changing it to ‘number’ with a value of 0.5.
See this post ?

Colin.

——————————
colin mcilwain
Lead Process Specialist
——————————
——————————————-

[Sam Duval]

Thanks not sure why that would make a difference, but it did the trick. Table formats correctly now.

thanks.?

——————————
Sam Duval
Data Quality Analyst
Indianapolis
——————————
——————————————-