Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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 , You have used stacked chart visual for that
Thanks @amitchandak , hovewer Im not sure it possible. Could our share the link with the decision ?
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! 😀
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! 😀
Thanks @lkalawski for your kind attention!
Added some sample data in the header.
@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! 😀
Thank you, @lkalawski !
But we lost 2019 forecast + fact.
It should be able to visual all 4 measures on 1 chart.
@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! 😀
Hello @KonstantinD
Use this link to find a file:
https://file.io/vDcAnEJdObtq
_______________
If I helped, please accept the solution and give congratulations! 😀
@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! 😀
Hi @Anonymous
Please check this link: https://file.io/acp97HHdNhyJ
_______________
If I helped, please accept the solution and give kudos! 😀
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |