Forum Discussion
Solved
Conditional Formatting - Icons - Scientific Numbers
I am wanting to use the icons conditional formatting option on a column which is based off another column I have created The issue is that the new column is returning a scientific number. Even if...
Hi jyouens
You may try rounding the numbers visibly in the measure for conditional formatting. For example,
Rule Measure = ROUND ( SUM ( 'Table'[Column B] ), 0 ) - ROUND ( SUM ( 'Table'[Column A] ), 0 )You can also choose to use ROUNDDOWN or ROUNDUP per your need.
Hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi jyouens
You may try rounding the numbers visibly in the measure for conditional formatting. For example,
Rule Measure = ROUND ( SUM ( 'Table'[Column B] ), 0 ) - ROUND ( SUM ( 'Table'[Column A] ), 0 )
You can also choose to use ROUNDDOWN or ROUNDUP per your need.
Hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
this worked, thank you! Anonymous