Duplication of rows in column sorted by another column

[jonasr]

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

[v-haibl-msft]

@jonasr

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