Forum Discussion
Direct Query - Multiple sorting in 100% stacked bar chart by Akvelon 1.2.3
Hi Anonymous ,
2. Sort by DESCRIPTION in custom order based on the following list. => I used the "Sort by Column" function in the model and select the "Description" column and choose "Sort by -> SequenceId". This way allows me to sort the Description based on the sequence order as per the SequenceId.
SequenceId Description 1 Purchase Order Import 2 Sales Order Import 3 PO Control Export 4 Booking Import 5 Cargo Booking Import 6 CFS Receipt Import 8 Shipment Auth Export 9 Shipping Import 11 Shipment Status Import 12 Load Manifest Export 13 Advice Of Departure Export 14 Strix Export 15 Customs Clearance Import 17 Landside Import 19 Landside Arrival Export 20 Landside Delivery Booking Export 21 Landside Delivery Receipt Export
Have you put [Description] column of the above sorting table into the chart field to replace [Description] column of your fact table?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Icey Yes I did exactly the same as what you mentioned below but the sorting still didn't work -> I put the [Description] from the below table (with Sort By Sequence Id) into the chart axis and I did not use the [Description] from the fact table, so ideally the chart sorting should follow the sequence according to the Sequence Id but unfortunately it did not 100% follow to the desired sequence.
Best regards,
Emily
Hi Anonymous ,
So weird. It works well on my side.
Can it work in other charts?
Best Regards,
Icey
Icey I haven't test for other visuals because I really need to use this plug-in one as it suits our needs with multiple variables.
Do you mind to share your testing file with proper sortings for both of the Timestamp and Description?
Thanks!
Best regards,
Emily