Forum Discussion
Fillable column in barchart
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 |
Hello @KonstantinD
Use this link to find a file:
https://file.io/vDcAnEJdObtq_______________
If I helped, please accept the solution and give congratulations! 😀
18 Replies
- lkalawski
Resident Rockstar
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! 😀- 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! 😀
- amitchandak
Super User
Anonymous , You have used stacked chart visual for that
Thanks amitchandak , hovewer Im not sure it possible. Could our share the link with the decision ?
