Changing a percentage measure to a number between 1 and 100

[Anonymous]

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:

AVAILABILITY CALCULATION =

1 - DIVIDE(('Table1'[Products]), ('Table1'[Products out of stock]))

Thanks all 🙂

[Anonymous · Accepted solution]

Ah just figured it out - I needed to Calculate 100 * the measure first, this then gives me a usuable figure 🙂

[Anonymous]

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

[amitchandak]

@Anonymous , on column or measure tool, you have % icon, if you press that it should become % ,

Click on the name in field pane