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

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

        Hi Anonymous ,

        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.