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 - I'd like to use the Soza Health Dial visual on a report and I have a measure thats giving me an availabilty percentage calculation, but when I use it in the visual it displays 80% as 0.8 for instance
What do I need to do to my measure to change 0.8 to 80? (so it s whole number out of 100)
I've built it using '1 minus the calculation' to get the remaining percentage value (its then formatted as a percentage), I tired formatting as a number but that gives 0.8 - I tried just multiplying the calculation by 100 using '* 100' but that didnt work. My measure is:
Solved! Go to Solution.
Ah just figured it out - I needed to Calculate 100 * the measure first, this then gives me a usuable figure 🙂
Ah just figured it out - I needed to Calculate 100 * the measure first, this then gives me a usuable figure 🙂
thanks - I've managed to get it to a number instead of a percentage, what I want it to change it from 0.8 to 80 - any ideas on how to do that?
The visual only uses numbers 1 to 100
@Anonymous , on column or measure tool, you have % icon, if you press that it should become % ,
Click on the name in field pane
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |