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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
geleigh
Frequent Visitor

Issues converting number into a percentage

Hi team,

 

I'm trying to calculate the percent of hours used over the hours budget which I was able to accomplish using DIVIDE.

 

When I go into 'show as a percent of grand total' it is showing the incorrect amount. How do I avoid this?

 

When I convert this column to a percent the numbers are not equal - what am I doing wrong? Thanks!

 

geleigh_0-1643315561323.png 

does not equal 

geleigh_1-1643315603492.png

 

So on the first line it has 6.05 and I need it to show 605%.

 

 

1 ACCEPTED SOLUTION
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

@geleigh - I am not sure what you mean by "Percentage of Grand Total".  If you convert the Number formatting from Decimal to Percentage then 6.05 will become 605%.  But changing the measure to "Percentage of Grand Totals" is different Measure.  605% as Percentage of X?

View solution in original post

3 REPLIES 3
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

@geleigh - I am not sure what you mean by "Percentage of Grand Total".  If you convert the Number formatting from Decimal to Percentage then 6.05 will become 605%.  But changing the measure to "Percentage of Grand Totals" is different Measure.  605% as Percentage of X?

So if i change the formula to 

Hours_Actual divided by Hours_Budget =
DIVIDE(SUM('Projects'[Hours_Actual]), SUM('Projects'[Hours_Budget])) * 100 it is still showing the incorrect amount.

Of course I just needed to change the number format - sometimes it's that obvious. Thank you!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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