Several Values for Stacked Column Chart

[Anonymous]

Hello everyone,

I have this dataset:

Dimension	Column1	Column2	Column3	Column4
row1	22	32	77	Extern
row2	11	43	68	Extern
row3	44	54	87	Extern
row4	33	65	98	Intern
row5	55	76	89	Intern
row6	66	78	87	Intern

And I need to represent a chart where divides each column (column1, column2 and column3) by Extern or Intern (it's going to be the Legend taken from column4) and it is possible to do it with the Stacked Column Chart, but the difference here is that I have several rows for Axis Field and several columns for Values Field... and this chart looks like only accepts one single column in the Values Field because it doesn't allow to put more than one...

Please, anyone could help me to show the values of column1, column2 and column3 divided by the legend (Extern and Intern). This is what I would like to get:

Thank you so much, I will appreciate your help.

Have a nice day.

Ana M.

[MFelix · Accepted solution]

Hi @Anonymous ,

For achieving this you need to unpivot the values columns. On the query editor select the column 1,2 ,3 and then unpivot:

It will give you the result below:

Rename the columns has you wish and do your chart using the following setup:

[Anonymous]

Thank you so much both of you! @MFelix I used your method and it worked very well, thanks a lot! 🙂

[amitchandak]

@Anonymous , You can either have a legend or multiple measures/values

There is a custom visual if that can work

https://www.defteam.com/stacked-clustered-bar-chart/

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview