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