cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Hector78 Regular Visitor
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%...

2me.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

So, sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User
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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Hector78 Regular Visitor
Regular Visitor

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

I need to calculate the percentage.

Super User
Super User

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

So, sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

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

Microsoft Implementation for Communities Wins Award

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

Power Platform World Tour

Find out where you can attend!

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