Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
You need to create a ranking column and sort it.
I don't know if you can do this with SSAS live connection
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |