Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 resul...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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 Li

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi 

     

     

    • v-yingjl's avatar
      v-yingjl
      Community Support
      6 years ago

      Hi Anonymous ,

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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!!!