custom sort legend changing data

[aebbage]

Hi,

I have created a custom sort column for my data to sort the legend on my graph, however when I sort by the new column, it changes the data.

Relationship:

BEFORE custom sort

Graph AFTER custom sort.

It seems to be changing the data, rather than sorting it.

I've never had this issue before. I have used this method many times. The only difference to previous times using this method, is that I am filtering the questions to display and filtering on year/term as all data is in the same back table now.

Thanks

[Ritaf1983 · Accepted solution]

Hi @aebbage 
Something with your relationship is wrong + The sort column should have unique values and in the picture you added there are 2 zeros.

I created the pbix with the logic like yours, you can download it and follow my steps.

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