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 noticed strange behaviour when trying to sort stacked bar chart by an overall sum of stacked values.
I set the variable in Axis (name) to sort by column (in Modelling) created by the following command where the c var cointains the sum of the stacked vars:
SortingCol = RANKX(ALL('table'),'table'[c],,DESC)
When the soring is set, it duplicates the values in the chart. As can be seen in the example below, the correct display is in the top chart (before setting the sorting) and the incorrect result after the sorting is in the bottom chart.
Any idea what is causing this behaviour and how to solve it?
Thanks,
Jonas
I tested with following simple data and did not see the strange behavior. Could you please give some more details about your data to repro it?
Best Regards,
Herbert
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |