Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Slicer Sort is broken

The slicer sort is broken in PowerBI desktop.

I am on Version: 2.97.861.0 64-bit (September 2021)

 

I have a very simple problem. I have a version number that is text, that I want in the slicer. I then have a order column. I created a Sort Order column that turns the date into a number. I should not have to do that. But I was worried it was a date issue. But it's not.

 

Yes I set "sort by column" in "column tools". Then I go to the slicer and sort by accending. As the screenshots below show it's clear that the slicer is ignoring the sort.

 

briandpeterson_0-1632756671740.png

 

briandpeterson_1-1632756682796.png

See file https://www.dropbox.com/s/5z0caua1wued91z/SlicerProblem.pbix?dl=0 

Help!

 

 

Status: New
Comments
v-chuncz-msft
Community Support

@briandpeterson 

 

You need to select the column(Version) that you want to sort, then select Sort by Column.

https://docs.microsoft.com/power-bi/create-reports/desktop-sort-by-column

briandpeterson
Advocate I

Oh I missed that you had to select the column you wanted first. My bad. Thanks!