cancel
Showing results for
Did you mean:
Hector78 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!

Hector78 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 