Forum Discussion

aebbage's avatar
aebbage
New Member
2 years ago
Solved

custom sort legend changing data

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

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

     

     

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    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.