Sort Order not working

[Daniel_B]

Hi All

I've followed the exact same patterns, methods and relationships as previous but for some reason my visual won't sort the values by the order I've chosen in the index table

Summary

table with data has field call SENTIMENT (Positive, Negative, Mixed, Neutral)

index table has 4 different sentiments, with conditional column (1-4 respective ordering) and has been sorted by ascending

When I add the visual to my legend the order is still mixed up

Again, this is exactly what I've done for about 9 or 10 other reports but this one is just being a pain

Any ideas?

Thanks

Dan

[amitchandak]

Just Check, That sort column has changed. It happens once with me that it did not save. I have to do it again.

Also, visual sort by default on value. Click on three ... and check the sort column is correct.

[Daniel_B]

@amitchandak - tried that, tried reordering the sort to see if there was an issue, tried changing the relationship to see if it would make any difference and it is still mixed up

Thanks for coming back though

[amitchandak]

Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...