Two columns Y Axis

[EricHHA]

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

[v-yingjl]

Hi @EricHHA ,

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 Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[EricHHA]

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

[v-yingjl]

Hi @EricHHA ,

My pleasure. It's a waterfall chart.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[EricHHA]

@v-yingjl I'm struggling to design a graph like yours. Based upon the excel below, how can I have one graph for the column "Grant KBRL" and other three for each other column, like yours?

How is the data in your excel?

https://imgur.com/m3fNAXh

TKs!!!

[v-yingjl]

Hi @EricHHA ,

Seems like two different tables in a single file.

My sample is very simple, just have one tabe like this:

If there are two tables, I'm afraid it could not achieve it at the same time currently because the total column is an attribute of its own in waterfall chart.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[EricHHA]

Hi @v-yingjl 

The img that I posted, shows a single table, with that many columns.

There isn't a workaround using another tool to achieve what I need?

Tks a lot

[v-yingjl]

Hi @EricHHA ,

Maybe like this?

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@EricHHA , you might have to use some custom visual for that

[Pragati11]

HI @EricHHA ,

Can you please post some sample data, so that this scenario can be tried?

Thanks,

Pragati

[EricHHA]

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. 

https://imgur.com/a/Dj9BVl4