Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi @luvagoldenk9 ,
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.
Hi @luvagoldenk9 ,
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.
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
Proud to be a Super User!
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!
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
Proud to be a Super User!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |