Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Stacked Bar with Line- with two columns

Dear Team,   we are trying to replicate something as shown in below image, the problem is Stacked bar with line only allow us to use one column/dimensions. basically, we need to see category one ye...
Need Help
Show and Tell
Tips and Tricks
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

You can put the three measures as you said into the "Column values", for example the picture below. Or could you please show me your desired output screenshot?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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
    7 years ago

    Hi Amy,  Thanks for replying,

     

    The Screenshot is desired output, we need Month on x axis and category on y axis, and the measures should be making upto bars.

     

    example. we are showing total sales over category and month. how much sales generated in Jan'18 in category chairs. Now here only one measure as sales sum, but i want plot Sales, Cost, and margin, sales and cost as stacked bar and margin as a line. Hope this helps.

     

    • v-xicai's avatar
      v-xicai
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous ,

       

      So the "ALS","BDT","CPS" and "CSUB" in your screenshot is refer to four categories name in category column?

      If yes , it is not supported to implement your desired output in Power BI Desktop currently ,while you can post your new idea here, to improve the Power BI Desktop.

       

      Best Regards,

      Amy

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Yes , ALS BDT are the categories, thanks for the suggestion, will post there