Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
kamini
Helper III
Helper III

Extra Unwanted Zeros for Values showing percentages.

Well, I can't get rid of the additional 00's in front of my % values. See below,

The Data in Excel is in Number-Decimal

In Excel:

kamini_1-1728399472441.png

In Power BI Result (Table)

kamini_0-1728399348445.png

kamini_2-1728399577745.png

Any help on this is greatly appreciate it. 

1 ACCEPTED SOLUTION

If 3 is supposed to be 3% then you will need the number itself to be 0.03 since 3 as a percentage is 300%. Divide your numbers by 100 and you should be good to go.

 

In Power BI when you tell it to make 3, 14, 51, etc. decimals all it does is make it be 3.0, 14.0, 51.0. Then, when you turn that into a percentage it becomes 300%, 1400%, 5100%, etc. You need that actual decimal equivalent of the percentages you want. So 3% is 0.03, 14% is 0.14, 51% is 0.51.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
audreygerred
Super User
Super User

Can you share a picture of what your numbers look like that are set as decimals? If you have 0, 1, 3, 5, etc. then as a decimal that is set to show as a percentage they would appear as 100%, 300%, 500%. If you are looking for 1%, 3%, 5%, etc. then the numbers would have to be 0.01, 0.03, 0.05, etc. If it should be 10%, 30%, 50% then your numbers need to be .1, .3., .5, etc,





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Here is the picture of the numbers shown in Power BI Table.

kamini_0-1728401441652.png

and in Excel, here is what I have,

kamini_1-1728401495784.png

Thank you!

If 3 is supposed to be 3% then you will need the number itself to be 0.03 since 3 as a percentage is 300%. Divide your numbers by 100 and you should be good to go.

 

In Power BI when you tell it to make 3, 14, 51, etc. decimals all it does is make it be 3.0, 14.0, 51.0. Then, when you turn that into a percentage it becomes 300%, 1400%, 5100%, etc. You need that actual decimal equivalent of the percentages you want. So 3% is 0.03, 14% is 0.14, 51% is 0.51.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.