Forum Discussion
Sort Visual in Status Order - not alphabetical order
Hi!
Have a Details file with a field called 'Status'.
Manually added a new table called Status_Table (see below) that has 'Status' and 'StatusSort'. StatusSort is format whole number:
| Status | StatusSort |
| Submitted | 1 |
| In Review | 2 |
| Assign to Team Williams | 3 |
| Assign to Team Hoffmann | 4 |
| Assign to Team Michaels | 5 |
| Rejected | 6 |
Then set the Sort by column for this table to 'StatusSort':
In relationships tab, connected Status from the Details table to the StatusTable:
In clustered column chart visual, using StatusTable field 'Status':
In visual, Status continues to sort alphabetically instead of in StatusSort order. Any thoughts on to what piece is missing?
Thank you in advance!
Hi Anonymous ,
You could apply the [StatusSort] to Tooltip pane and sort by it like this:
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anonymous ,
You could apply the [StatusSort] to Tooltip pane and sort by it like this:
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.that help a lot, thank you!
- PhilipTreacy
Super User
Anonymous
Download sample PBIX with solution
On the Axis you need to add the Status from the Status_Table, not the one from the Details table
Regards
Phil
Hi Phil,
Yes I was using the Status from the StatusTable so that is why it was so confusing. I thought of adding more data to the list so used the developed Power App to add more data. Came back to the Power BI dashboard and hit 'Refresh' and now the Status sorts correctly. Thank you for diagrams as that helped to confirm it is accurate. Have a great day!
- timg
Solution Sage
Hi,
have you checked if the visual is sorted by the order status > ascending ? Perhaps it is currently still sorted by a different column/measure instead.
Best regards,
Tim
Hi Tim!
The visual was still showing the data in alpha Status order. So starting rethinking the whole process and went to add more data through the power app. Did a refresh to the Power BI report and now the Status shows in the correct order.
Thank you for your response as it helped me rethink it through. Have a great day!
