Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
smithmc3
Advocate I
Advocate I

Custom Sorting

‎03-01-2017 11:55 AM

So I am trying to sort based on Submission Status  and want to show the status in sequence order.  Additionally, we have developed slightly different names that we want to display for users.  I created a separate table to relate the old name (OName) to the new name (NNAme) and put in another column for the order in which we want them to show (Order).  Phase.PNGPhase Sort.PNG

 

I could not get it to sort based on the Order column no matter how I added it.  As a temporary work around I added it to the NName column as shown above.  Any thoughts on how I can get it to sort by the order column?

Labels:
Message 1 of 5
8,692 Views
0
2 ACCEPTED SOLUTIONS
Sean
Community Champion
Community Champion

‎03-01-2017 12:26 PM

select the OName column - Modeling Tab - click Sort By Column - select Order from the dropdown Smiley Happy

View solution in original post

Message 2 of 5
11,043 Views
v-caliao-msft
Microsoft Employee
Microsoft Employee

‎03-06-2017 10:46 PM

Hi @smithmc3,

 

Please refer to the screenshot below to change oders of you Axis items.
Capture.PNGCapture1.PNG

 

Regards,

Charlie Liao

View solution in original post

Message 3 of 5
11,008 Views
0
4 REPLIES 4
v-caliao-msft
Microsoft Employee
Microsoft Employee

‎03-06-2017 10:46 PM

Hi @smithmc3,

 

Please refer to the screenshot below to change oders of you Axis items.
Capture.PNGCapture1.PNG

 

Regards,

Charlie Liao

Message 3 of 5
11,009 Views
0
smithmc3
Advocate I
Advocate I
In response to v-caliao-msft

‎03-10-2017 04:53 AM

So, I tried that and it stays the same, thoughts?

 

Custom_Sort Update.png

 

Message 4 of 5
8,636 Views
0
smithmc3
Advocate I
Advocate I
In response to smithmc3

‎03-10-2017 05:39 AM

Thanks guys! I refreshed the data a few times and saved and now it seems to be working! 

Message 5 of 5
8,630 Views
0
Sean
Community Champion
Community Champion

‎03-01-2017 12:26 PM

select the OName column - Modeling Tab - click Sort By Column - select Order from the dropdown Smiley Happy

Message 2 of 5
11,044 Views

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All