Sorting barchart with two date calculations not working

[FredrikJ]

Hi!

I have a bartchart with two date calculations as legend ( WTD and WTD LY). When I try to sort the axis after the value (Sales Net) it will not sort, it still sort alphabatically after the x-axis(Region). If the chart only have one date calculation in the legend the sort with value (Sales Net) works fine. The Report is built on a dataset with live connection to a multidimensional SSAS cube.

Regards

Fredrik

[v-jingzhang]

Hi @FredrikJ 

When it has multiple values in the legend, it would be ambiguous when trying to sort by the value as the sorting result would be different for each legend value. I think that's why it works fine when the chart only has one date calculation in the legend, but fails when having two. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[freginier]

You need to create a ranking column and sort it. 

I don't know if you can do this with SSAS live connection