Reply
Weatsop
New Member

Very newb: sideways table / chart with column headings as y-axis, this is probably really obvious

I don't even know what words to search for. Apologies if this is obvious.

 

Here's a table:

NameRegionBigMidLittle
JulieNorth13512
MarkusNorth161812
MarkusSouth12621
UmaNorth139

1

 

What I'm trying to do is get a horizontal stacked bar chart, that has Big, Mid, and Little down the Y axis. Each of the 3 bars should be stacked from Jule's, Markus' and Uma's numbers. Note that from Markus I just want the one number (north and south combined).

 

I feel like I'm missing something very obvious, but I've spent a stupid amount of time going crazy.

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @Weatsop ,

 

the point is to first unpivot your data to something like below:

FreemanZ_0-1730351654132.png

 

then everything becomes more intuitive:

FreemanZ_1-1730351683280.png

 

About unpivot, please refer to the attachement or check here:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

 

 

View solution in original post

2 REPLIES 2
Weatsop
New Member

Thank you so much! Turns out I had tried something like that.... a couple of hours ago... and didn't set the Legend. GAH!

 

You've saved me probably half a day of misery and shame. Thanks!

FreemanZ
Super User
Super User

hi @Weatsop ,

 

the point is to first unpivot your data to something like below:

FreemanZ_0-1730351654132.png

 

then everything becomes more intuitive:

FreemanZ_1-1730351683280.png

 

About unpivot, please refer to the attachement or check here:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

 

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)