Fillable column in barchart

[Anonymous]

Hello, guys!

Is it possible to do the same in PBI ? 

Left bar - last year (forecast  70,3 + fact measures 71,5)

Right bar - current year (forecast 74,8 + fact measures 71,5)

 X asis - months

There is Excel column chart throught overlapping axis.

Sample data:

Month	2019_for	2019_fact	2020_for	2020_fact
Jan	70,3	71,5	74,8	71,5
Feb	69,9	71,4	74,7	73,3
Mar	69,9	71,3	76,2	73,5
Apr	69,4	70,1	77,4	49,3

[amitchandak]

@Anonymous , You have used stacked chart visual for that

[Anonymous]

Thanks @amitchandak , hovewer Im not sure it possible. Could our share the link with the decision ?

[lkalawski]

Hi @Anonymous

Yes, you can use Stacked Bar chart with Legend.

To have a different measure on the left and a different measure on the right, you must write the appropriate measure for this.
Provide sample data, or upload a file without private data.  

Please check this: https://www.tutorialgateway.org/power-bi-stacked-bar-chart/

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Hey, @lkalawski 

Its not stacked bar, unfortunately.

There are two  overlaped charts.

[lkalawski]

Hi @Anonymous 

Ok, could you please upload some sample data to create a chart or a .pbix file? I'll try to create a similar chart.

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Thanks @lkalawski  for your kind attention!

Added some sample data in the header.

[lkalawski]

@Anonymous

If you want to do it on one chart, I can only suggest this solution:

Unfortunately, it cannot be set otherwise.

Possibly a combination of two graphs.

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Thank you, @lkalawski !

But we lost 2019 forecast  + fact.

It should be able to visual all 4 measures on 1 chart.

[lkalawski]

@Anonymous 

On the picture you can find forecast + fact for 2019, please check the labels. Jan 2019 and Jan 2020 (on the bottom you have fact value, on the top forecast). 

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Oh! Soryy, @lkalawski - got it.

COuld you please share pbx ? 

[lkalawski · Accepted solution]

Hello @KonstantinD

Use this link to find a file:

https://file.io/vDcAnEJdObtq

_______________
If I helped, please accept the solution and give congratulations! 😀

[Anonymous]

Many thsnks @lkalawski

[lkalawski]

@KonstantinD , try this: https://file.io/tg6Wj9udscZ8

[Anonymous]

same @lkalawski  )

404

could you please add pbix to the message ?

[lkalawski]

@Anonymous

As I know, we can't add files directly to the message. Correct me if I'm wrong.

I'm afraid I have lost this file because it has expired. I will try to create it today again and send you a link.

______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Thank you so much @lkalawski !

[lkalawski]

Hi @Anonymous 

Please check this link: https://file.io/acp97HHdNhyJ

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Yeah! Thats it!

Many thanks @lkalawski !