cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors