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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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!