CODEWITHSUNDEEP
powerbipowerbi-desktop
Iftekhar
Iftekhar

Reputation: 365

Percentage shows 10000% instead of 100% in Power BI. How to fix this?

I have been trying to get Power BI to show me the actual value of a percentage which is 100% or anything below than that for my report but what it rather does is it displays 10000% instead of 100%.

How can I sort it out? I have attached a screenshot for your convenience. Files used : Microsoft Excel

powerbi

Upvotes: 1

Views: 16179

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40264

As @underscore_d points out, percentages between 0% and 100% correspond to numeric values between 0 and 1. So, if your data is in the range of 0 to 100, this corresponds to 0% to 10000%.

To fix this, you can divide the column by 100 in the query editor. To do this, select the column and go to Transform tab > Number Column section > Standard > Divide and divide by 100.

Screenshot

Upvotes: 2

Related Questions