cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luvagoldenk9
Helper I
Helper I

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:

 

StatusStatusSort
Submitted1
In Review2
Assign to Team Williams3
Assign to Team Hoffmann4
Assign to Team Michaels5
Rejected6

 

Then set the Sort by column for this table to 'StatusSort':

StatusSort.jpg

 

In relationships tab, connected Status from the Details table to the StatusTable:

 

In clustered column chart visual, using StatusTable field 'Status':

StatusSort3.jpg

 

In visual, Status continues to sort alphabetically instead of in StatusSort order. Any thoughts on to what piece is missing?

 

Thank you in advance!

 

1 ACCEPTED SOLUTION
Eyelyn9
Community Support
Community Support

Hi @luvagoldenk9 ,

 

You could apply the [StatusSort] to Tooltip pane and sort by it like this:

2.15.4.1.gif

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.

View solution in original post

5 REPLIES 5
Eyelyn9
Community Support
Community Support

Hi @luvagoldenk9 ,

 

You could apply the [StatusSort] to Tooltip pane and sort by it like this:

2.15.4.1.gif

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.

timg
Solution Sage
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.

timg_0-1612913367376.png

Best regards,

Tim





Did I answer your question? Mark my post as a solution!

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!

PhilipTreacy
Super User
Super User

@luvagoldenk9 

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

statsort.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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!

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors