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

## 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
Established Member

## Re: Calculate percentage for clustered column chart

What is your desired output (as a table)?

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

## Re: Calculate percentage for clustered column chart

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

Proud to be a Datanaut!

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

## Re: Calculate percentage for clustered column chart

Use a tooltip to show it.

Regards

Victor

Lima - Peru

Proud to be a Datanaut!

Frequent Visitor

## Re: Calculate percentage for clustered column chart

Hi,

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

Thank you!

Super User

## Re: Calculate percentage for clustered column chart

I think that feature is not available yet.

Regards

Victor

Lima - Peru

Proud to be a Datanaut!

Highlighted
Frequent Visitor

## Re: Calculate percentage for clustered column chart

Thank you ! appreciate your help!

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.