cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper II

## 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
Super User

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))`

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
3 REPLIES 3
Super User

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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Helper II

I need to calculate the percentage.

Super User

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))`

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...