cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SoDoLabs
Regular Visitor

Sort Slicer Value By A Different Column

Hi,

I'm trying to sort the values in a slicer based on a different column within the same table. I was able to find the following post; however, the solution didn't work at my end.

https://community.powerbi.com/t5/Desktop/How-can-I-sort-the-text-values-in-a-filter-object/m-p/24603...

I followed the post and made sure I set Sort by Column with the column that I want to use for sorting, but I’m not seeing the expected sorting results.

 

I would like to see slicer values in the following order:

  • CCC
  • DDD
  • AAA
  • BBB Picture1.png

 

Thank you for any help you can offer!

1 ACCEPTED SOLUTION
jdbuchanan71
Super User II
Super User II

Hello @SoDoLabs 

What you need to do is select the column you are trying to sort (name in this case) then in the sort by drop down pick the column you want to use (order).

 

SortByOrder.jpgSortByOrderFixed.jpgSortByOrderSlicer.jpg

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User II
Super User II

Hello @SoDoLabs 

What you need to do is select the column you are trying to sort (name in this case) then in the sort by drop down pick the column you want to use (order).

 

SortByOrder.jpgSortByOrderFixed.jpgSortByOrderSlicer.jpg

View solution in original post

@jdbuchanan71 ,

 

It makes so much sense now. Thank you for your response!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.