Forum Discussion
Simple sort issue
Here is the pbix .
Please select the Priority column, then click on Sort by and choose the Order column.
Hey Anonymous
can't you just add a number before the text?
Like 0 - Low, 1 - Medium, 2 - high ecc?
Not a satisfactory solution?
Won't work as the priority column has a relationship with the main table of the same name.
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?