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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Create a specific stacked column chart

Hello,

 

I am making dashboard for my internship and I don't know how to make a specific chart.

My datas are stocked in a table, in a similar way to this one.

 

Horus33_0-1673626564652.png

 

And I have to recreate this table on Power BI.

 

Horus33_1-1673626627032.png

So I need to get the Antimalware, Update Status, Online and Managed in four separate columns in Power BI. I tried to use the Stacked column chart and the 100% Stacked column chart, but without success in both cases. When trying to adjust the parameters, I end up with things like this or this (or others, but none of them as I would like.

Horus33_2-1673626894514.png

Horus33_3-1673626915047.png

 

If you have any idea on how to solve this and make it works, this would help me a lot ^^'>

If it is even possible to get what I'm trying to do, which I'm not sure...

 

Thank you !

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi There,,
i think you want something like this, 

olgad_0-1673628647713.png

In Power Query Editor Select 4 columns you have and click unpivot columns

olgad_1-1673628715156.png

olgad_2-1673628737426.png

After, create a stacked column chart and there you have it.

olgad_3-1673628794018.png

 

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

1 REPLY 1
olgad
Super User
Super User

Hi There,,
i think you want something like this, 

olgad_0-1673628647713.png

In Power Query Editor Select 4 columns you have and click unpivot columns

olgad_1-1673628715156.png

olgad_2-1673628737426.png

After, create a stacked column chart and there you have it.

olgad_3-1673628794018.png

 

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.