Stacked Bar with Line- with two columns

[Anonymous]

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 year trend so we need to use one date column and one category column with three measures. Is it possible?

[v-xicai]

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]

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]

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]

But is there any other visual suggestion that we can do for this type of requirement.

[Anonymous]

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