Actual vs budget chart in powerBI

[athiramkrishnan]

Hi,

Can anyone please help me to include budget and plan in a stacked bar chart.

[athiramkrishnan]

@Seanan 

[athiramkrishnan]

Hi Seanan,

I am in a need of bringing dual axis to a stacked bar chart in power BI.

So the bar chart should show the Sales Qty of current year and previous year and should be stacked based  on the plants.And in the same bar chart I need another bar showing the budget qty with the sames stack seperations.

Here the first 2 graphs shows Actual Sales and the one on the right shows budget. This is actually 2 graphs which I have kept one on top of another. Is there a way to get this as one chart.ie dual yaxis for a stacked column bar chart.

[Anonymous]

Hi @athiramkrishnan I am facing similar problem. Did you solve it by any chance? Please guide me if you did. 

Hi @Seanan I am still struggling with the same issue.
Here is my data set and chart I want to view:

Basically the next year needs to show bud and current and previous year needs to show Actual.

[Seanan]

Hi @athiramkrishnan 

Could you please provide more information such as the dataset you are using?