Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Direct Query - Multiple sorting in 100% stacked bar chart by Akvelon 1.2.3

Hi,   I have a visual like the below using Direct Query and would like to do custom sorting by different variables simultaneously.     1. Sort by TIMESTAMP in decending order (ie. 5/jun, 4...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

I may find the cause. This problem is caused by the visual principle rather than the model.

For the 1st column,

  1. show [Description] of "Succeeded" containing values/records, based on custom order;
  2. show  [Description] of "Failed" containing values/records, based on custom order;
  3. For other [Description] containing no values/records, sort by the order of values/ records  appearance, so the first one of the rest  [Description] is "Shipment Auth Export", which appears values/records first in 2nd column.

 

 

I have tried my best to explain clearly and hope you can understand.

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Icey  Thank you so much for your clear explanation and the animation. I got your point and it seems the problem came from the design of the custom visual rather than from the data as what you said. I tried workarounds such as using DAX to enforce a value for the counting and not to leave it as blank for those Descriptions without data, unfortunately it didn't work for this type of chart.

Right now I don't have any other solutions to solve this matter unless if I give up this chart type. Anyway thanks for your help again and have a good day!

 

Best regards,

Emily