Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I am trying to do nested sorting in a stacked column chart and would appreciate any guidance on how to do it. This is my notional data:
This is what my stacked column chart (of number of parts by model & company) looks like, where the x-axis is showing the Model and Company, and y-axis is showing the count of Part Description (i.e. the total number of parts) broken down by Location (legend):
I have this set to Sort Axis by # of parts (descending), which is sorting the Models correctly but incorrectly grouping the Company. What do I need to do to sort this by the y-axis but the columns arranged by Company (so the order would be Lexus->Corolla->Camry-> Accord->Sonata)?
Thanks for any help!
Solved! Go to Solution.
Hi @fz1
You need to create two order tables.
Merge each of the two order tables with the original data table.
Expand the merged table, keeping the sort column.
Click Close&Apply.
Sort the Company and Model columns according to the following actions.
Result:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @fz1
You need to create two order tables.
Merge each of the two order tables with the original data table.
Expand the merged table, keeping the sort column.
Click Close&Apply.
Sort the Company and Model columns according to the following actions.
Result:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @fz1
I am not sure with your current configuration it is possible to custom sort. But i tried to work around if it makes sense you can use that. Here is my Approach
Step 1: Create Custom column based on sorting order
Step2: use this confriguration:
And i have sorted this with new created custom sort column
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more interesting solution here: www.youtube.com/@Howtosolveprobem
Regards
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
36 |