The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
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
But is there any other visual suggestion that we can do for this type of requirement.
Yes , ALS BDT are the categories, thanks for the suggestion, will post there
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
139 | |
110 | |
107 | |
76 | |
62 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |