Forum Discussion
Simple sort issue
Here is the pbix .
Please select the Priority column, then click on Sort by and choose the Order column.
Don't modify the column used for the relationship, but add a new column in the table Prioritisortorder with the number as prefix, then use this new column for the visual leggend.
Now I'm thinking that if you sort the priority column by order column should work also.
Go in the data view, then select the priority column, then sort by order column
Tried - Nope 😕
I even tried to sort by legend as well as Details...nope
Are you sure? I've tried with simple data and both the methods worked good.
Could you load your pbix?
I am not able to share the pbix due to company's policies 😕
Is it possible you can show me the snapshots to what you did?
Here is the pbix .
Please select the Priority column, then click on Sort by and choose the Order column.
Also, it seems that in the screenshot you provided, you’re not sorting the priority column by order but rather sorting the order column itself.
Additionally, if you set up the order column this way, you should use the order column as the legend instead of the priority column.