cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mason23 Frequent Visitor
Frequent Visitor

Calculate percentage for clustered column chart

Hi, 

How can I create a mesaure to calcuate percentage given this dataset?

 

Total   CategoryID
1         5
1         6
1         3
1         4
1         2
1         5

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Calculate percentage for clustered column chart

hi, @mason23 

Here is a same case I have solved that might work for you.

https://community.powerbi.com/t5/Desktop/Problem-include-and-value-in-graph/m-p/586646#M278050

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 REPLIES 9
HotChilli Established Member
Established Member

Re: Calculate percentage for clustered column chart

What is your desired output (as a table)?

mason23 Frequent Visitor
Frequent Visitor

Re: Calculate percentage for clustered column chart

Thank you for the reply. Would like to show value and percentage in a clustered column chart visual.

Super User
Super User

Re: Calculate percentage for clustered column chart

@mason23 

 

 

Hi, Insert The Category  in Axis and Total in Values

 

Finally Click on Total (In Values Section) in the inverted triangle  and Select Show Value as ---Percent of grand total.

 

Regards

 

Victor

 

 




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

Proud to be a Datanaut!




mason23 Frequent Visitor
Frequent Visitor

Re: Calculate percentage for clustered column chart

That works for showing the percentage %.  I'd like to show total number  and percentage per category ID as well.

 

example. 

 

category 1 = 1,500 68%

 

Thank you!

Super User
Super User

Re: Calculate percentage for clustered column chart

@mason23 

 

Use a tooltip to show it.

 

Regards

 

Victor




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

Proud to be a Datanaut!




mason23 Frequent Visitor
Frequent Visitor

Re: Calculate percentage for clustered column chart

 

PBi.PNG

 

Hi,

This is my column chart. I can show either value or percentage but not both. 

 

 

Thank you!

Super User
Super User

Re: Calculate percentage for clustered column chart

@mason23 

 

I think that feature is not available yet.

 

Regards

 

Victor




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

Proud to be a Datanaut!




Highlighted
mason23 Frequent Visitor
Frequent Visitor

Re: Calculate percentage for clustered column chart

Thank you ! appreciate your help!

Community Support Team
Community Support Team

Re: Calculate percentage for clustered column chart

hi, @mason23 

Here is a same case I have solved that might work for you.

https://community.powerbi.com/t5/Desktop/Problem-include-and-value-in-graph/m-p/586646#M278050

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.