Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone !!
I got a card and Icon which shows the fillrate% and the indication icon respectively.
I have attached below the images of it .
Requirement : I want the card and Icon to turn green when the % is above 99.00 % . So when it's below 99.00 ( red ) and when above 99.00% (green)
I tried some measures and I could get the red colour but it isn't changing to green when it's above 99% . Appreciate any help .
Thank You
@PaulOlding @v-shex-msft @v-jianboli-msft Thank you all who helped me previously.
Solved! Go to Solution.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |