Forum Discussion
Several Values for Stacked Column Chart
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.
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:
3 Replies
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
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:
Thank you so much both of you! MFelix I used your method and it worked very well, thanks a lot! 🙂
