Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |