Visualisation with charts

[kitala11]

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)

[Anonymous]

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.

[kitala11]

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

[Anonymous]

Hello @kitala11 
You can use thevcustom visual "Ultimate Stacked Free 4.2.0"

[kitala11]

that is exactly what I have.... which i mentioned that i am looking for other options because it is not presentable

[v-deddai1-msft · Accepted solution]

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

[Anonymous]

As per my knowledge Power BI doesn't allow multiple values if you don't put values in the axis and if you put the only legend it will allow one value only.
You may try custom visual "Multiple Axis Chart - xViz"

[kitala11]

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.

[Anonymous]

Hello @kitala11 
Can you please provide in table format instead of image?

[VijayP]

@kitala11 

What is the final objective is most important to give a solution!