Forum Discussion
Overlapping/Forecasting Column Chart with two categories
Hey, I want to overlap column for 2023 Year for both of the Product As seen below in excel.
could we do that?, I tried overlapping options but it merges both the products...those overlapped portions are forecasting.
Please help!
Please make your data as per your convenience and share he pbix with me.
Yep, done, note that I put 3 different measures randomly, so you'll need to create a separate measure for the forecast.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Hi Krushnab85
Unfortunately, we don't have the option to select which category to overlap....As alternatives you can maybe use an error bar to show the forecast like:
or to check the option of combining stacked with clustered guides:
https://www.youtube.com/watch?v=v854w7XIRbQ
https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks for your attention, Could you share me this pbix file?
Yep, done, note that I put 3 different measures randomly, so you'll need to create a separate measure for the forecast.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
