Forum Discussion
Visualisation with charts
Dear all,
How can I make it such that I am using stacked bar chart but I want it to be combined in 1 graph like the one below? I can only manage to find one sort of visualization like that in PowerBI but the one below is quite unappealing. Does anyone know how to make it like the chart below using a more appealing chart like the line and stacked chart?? ( I tried but using the legend only allow me to add one column)
Hi kitala11 ,
I suggest you transform your table to the following format(unpivot the last three columns):
Then it will act like what you want:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
9 Replies
Hello kitala11
If forecasts are the measures then you can add them into the values.
Try and check or you can provide the sample data after removing sensitive data.I am adding them into values. However, I need to proj aprov to be in the legend for the stacked columns. The thing is if i have something in the legend. The values can only contain 1 (measure/column). Which is shown as the first top photo, that is how it looks like if I do it the way you are saying
Here is a sample data, you can imagine it for a few more months, but that is what the data looks like, besides the numeric value being altered by me.
