cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## How can I do that the values appear in percentage?

Hi.

I woul like that my values to appear as percentage.

For example Month 1 Ind_Proyectos_Partida=37.7%

, Month 10 Ind_Proyectos_Partida=2%

,Month 11 Ind_Proyectos_Partida=0.6%...

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: How can I do that the values appear in percentage?

That being said, you could use the "Show as Percent of Grand Total" option when you click the drop down arrow for the column. There is also probably a Quick Measure for this. But, the general formula for this is something along the lines of:

`Percentage = SUM([Column])/CALCULATE(SUM([Column]),ALL(Table))`

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

3 REPLIES 3
Super User

## Re: How can I do that the values appear in percentage?

To format something as a percentage, click on the column and go to the Modeling tab and click the "%" button in the ribbon. Not entirely sure what you are asking.

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Regular Visitor

## Re: How can I do that the values appear in percentage?

I need to calculate the percentage.

Super User

## Re: How can I do that the values appear in percentage?

That being said, you could use the "Show as Percent of Grand Total" option when you click the drop down arrow for the column. There is also probably a Quick Measure for this. But, the general formula for this is something along the lines of:

`Percentage = SUM([Column])/CALCULATE(SUM([Column]),ALL(Table))`

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,649)