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:
|Assign to Team Williams||3|
|Assign to Team Hoffmann||4|
|Assign to Team Michaels||5|
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!
Solved! Go to Solution.
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.
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!
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!
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!