Forum Discussion

jyouens's avatar
jyouens
Frequent Visitor
2 years ago
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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523