cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Resolver II
Resolver II

You must use the "100% stacked column chart"

View solution in original post

2 REPLIES 2
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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

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.

Top Solution Authors
Top Kudoed Authors