Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi I want to show clustered stack bars like the picture.
Thnaks,
Kharansu Rath
Solved! Go to Solution.
Hi @Anonymous ,
Please see the screenshot above. Let me know if you have any more doubts 🙂
Hello and welcome to the forums.
In the future please provide more information and data; What have you tried already? What worked? where did it went wrong? and give us sample data. Trust me, when you put a bit more effort in your question, we will put more effort in our answers and you will be helped sooner.
For more info: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Besides that. im not sure if it is possble to cluster them 2 by 2. I have seen people mess with data to create white spaced so that could be an option (measures with value 0 between bars).
If your talking about the dates and want to just have Jan 19 Jan 20 Feb 19 Feb 20. You can create a custom sort table of some sort. Use the search option on that if you dont know how that works.
Goodluck,
Eric.
Quality over Quantity
Hi Eric,
Thank you for the resonse. I have replied to Sud, if possible can you take the attached sample data and help me find the solution?
Regards,
Kharansu
Hi @Anonymous ,
1. Add a calculated column to the edit query part where you basically label 2019 months as Jan19, Feb19, and so on. Now, for Jan 20, you could use concatenate year and month.
2. Now, create a separate table where you list the order of priority in this format:
Jan 19 1
Jan 20 2
Feb 19 3
Feb 20 4
Now, just pull in the months and when ordering by, use the above order.
If this solution works for you, please accept it as solution to help others find it as well 🙂
Hi Sud,
Thank you for the response. I am attaching a sample data here. Kindly help me find a solution according to that.
Category | Sales Jan-19 | Sales Feb-19 | Sales Mar-19 | Sales Jan-20 | Sales Feb-20 | Sales Mar-20 |
Plastics | 30000 | 673700 | 125556 | 728863 | 23682873 | 9827929 |
Steel | 62000 | 667789 | 678996 | 665357 | 824728 | 29382398 |
Copper | 563678 | 635368 | 90111 | 897975 | 8267928 | 8838383 |
Regards,
Kharansu
Hi @Anonymous ,
Please see the screenshot above. Let me know if you have any more doubts 🙂
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |