Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mason23
Helper I
Helper I

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

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.

View solution in original post

9 REPLIES 9
Vvelarde
Community Champion
Community Champion

@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

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
Community Champion
Community Champion

@mason23 

 

Use a tooltip to show it.

 

Regards

 

Victor




Lima - Peru

 

PBi.PNG

 

Hi,

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

 

 

Thank you!

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.
Vvelarde
Community Champion
Community Champion

@mason23 

 

I think that feature is not available yet.

 

Regards

 

Victor




Lima - Peru

Thank you ! appreciate your help!

HotChilli
Super User
Super User

What is your desired output (as a table)?

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.