Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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.
@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
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...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 67 | |
| 65 | |
| 56 |