cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!

does not equal

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

1 ACCEPTED SOLUTION
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?

3 REPLIES 3
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?

Frequent Visitor

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.
Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors