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

Question about how to show subtotal percentage in Stacked column chart

Hi everyone~

 

i have a data sample is like:

IDTypeDetail
1A1
1A2
1A2
1A2
1A2
1B1
1B1
1B1
1B1
1B1
1B2
1B1
1B2
1B2
1B2
1B1
1C1
1C1
1C2
1C2

 

i wanna use the Stacked column chart  to show the data:

 

image.png

 

i want the data lable showing the percnetage of each type, not for the grand total. how can i do that?

 

thanks!

 

 

1 ACCEPTED SOLUTION
maguilarBI
Resolver II
Resolver II

You must use the "100% stacked column chart"

View solution in original post

2 REPLIES 2
maguilarBI
Resolver II
Resolver II

You must use the "100% stacked column chart"

View solution in original post

I am concerning that if i use it, i will lost the overall analysis, because the count of each items is also important.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.