Forum Discussion
Two columns Y Axis
Hi all,
I'd like to put two bars with similar Y axis, one to show the budget value and other a stacked column with three values within.
I tried to do it but couldn't put the two together. The result is like below on the print, it feels strange to look at it because the Y axis is very different, and what I really want to do is to visualize the right bar fulfilling until it gets like the "Budget" bar.
https://imgur.com/6Kqo8Hx (This was built in Excel, that's how I'd like to build)
https://imgur.com/9NyhLhf (In PowerBI)
Thanks in advance
10 Replies
HI Anonymous ,
Can you please post some sample data, so that this scenario can be tried?
Thanks,
Pragati
Hi Pragati, thanks for the reply.
I did upload an image of the date regarding the the first img of my post. The values highlighted in circle are the ones that I'd put on the graphs.
Anonymous , you might have to use some custom visual for that
Hi Anonymous ,
I'm afraid power bi cannot seem to meet your requirement 100% currently because your x-axis seems different.
Supposing that your data has a hierachy-level, using drilldown also cannot show the two columns at the same time. You can use waterfall chart to meet part of your requirement not all like this:
You can submit the requirement to ideas and add your comments there to help us improve power bi and make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yingjl, tks for the reply!
Could you please share the image of the right side of ur screen from PowerBi regarding this graph that u made?
Tks
Hi Anonymous ,
My pleasure. It's a waterfall chart.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
