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

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### November 2019 Community Highlights

Get an overview of the events and great community content from November.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)