Forum Discussion
Conditional formatting of Icon colour
prv_1401 Seems like your formula should be >0.99 instead of 99
prv_1401 Because the actual value is actually .996. You have it formatted to display as a percentage which makes it display on the screen as 99.60%. Formatting is separate from the actual value. In fact, the value may actually be .996 but since you have 2 decimal places of formatting it shows as 99.60%. Another example, the actual value might end up being .996347 but if you only have 2 decimal places of formatting then it will be 99.63%. Formatting is controlled via the Format section of the Measure Tools or Column Tools tabs in the ribbon. You can also have custom format strings, which are a treat.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
prv_1401 Seems like your formula should be >0.99 instead of 99
Greg_Deckler Thank you so much. It worked.
Can you tell me why should we put it in that way ( like 0.99) ?
I am new to PowerBI so curious to know .
prv_1401 Because the actual value is actually .996. You have it formatted to display as a percentage which makes it display on the screen as 99.60%. Formatting is separate from the actual value. In fact, the value may actually be .996 but since you have 2 decimal places of formatting it shows as 99.60%. Another example, the actual value might end up being .996347 but if you only have 2 decimal places of formatting then it will be 99.63%. Formatting is controlled via the Format section of the Measure Tools or Column Tools tabs in the ribbon. You can also have custom format strings, which are a treat.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Greg_Deckler Ok got it. Thank you so much ❤️