Calculate percentage for clustered column chart

[mason23]

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

[Vvelarde]

@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

[mason23]

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!

[Vvelarde]

@mason23 

Use a tooltip to show it.

Regards

Victor

[mason23]

Hi,

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

Thank you!

[v-lili6-msft · Accepted solution]

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

[Vvelarde]

@mason23 

I think that feature is not available yet.

Regards

Victor

[mason23]

Thank you ! appreciate your help!

[HotChilli]

What is your desired output (as a table)?

[mason23]

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