How to Sort Slicer in Power BI?

Do you know how to sort slicers in Power BI Desktop? No problem. In this tutorial, I will tell you how to sort slicer in Power BI and how to sort descending or ascending order in Power BI Slicer.

Also, I will explain how the Sort slicer value is based on the numeric value in Power BI.

How to Sort Slicer in Power BI

When we create a Power BI Slicer, you must see, by default, that it is sorted by ascending order, but we can change it in simple steps.

How to Sort Slicer in Power BI

The screenshot below represents a SharePoint list [Financial Sample] that I used for this Power BI Slicer.

ColumnsData Types
Month NameSingle line of text
SegmentSingle line of text
CountrySingle line of text
ProductSingle line of text
SalesCurrency
ProfitCurrency
How to Sort Slicer in Power BI

Now, we will see how to sort the slicer in Power BI in simple steps.

1. Open Power BI Desktop and load the data using the Get data option. Then, we can see the data set in the Data Panel.

power bi slicer sort order

2. Under the Visualizations panel, click the Slicer visual.

power bi sort slicer

3. Then drag and drop the Product into the Slicer Field.

Power BI slicer sort descending

4. Select the slicer and select the 3 dots () in the top right corner -> click Sort axis -> click Sort descending.

how to sort slicer in power bi desktop

This way, you can sort the slicer in descending/ascending order in Power BI.

How the Sort Slicer Value is Based on the Numeric Value in Power BI

Now, let’s create a numeric value slicer and explore how the slicer values are sorted based on the numeric value in the Power BI Report

1. Under the Visualizations panel, click the Slicer visual.

Sort Slicer Values by Number

2. Then drag and drop the Sales into the Slicer Field.

Sort slicer value based on the numeric Value

3. Select Slicer -> click Format your visual -> click Visual -> click Slicer settings -> In the drop-down, select Vertical list.

How to sort numeric slicer in power bi

4. Select the slicer and select the 3 dots () in the top right corner -> click Sort axis -> click Sort descending.

sort slicer in power bi desktop

This way, you can sort numeric value slicer in descending or ascending order in Power BI.

Conclusion

I hope you follow the above steps to Sort Slicer in Power BI. In this article, we learned how to Sort slicers in Power BI in alphabetical order.

Also, we discussed how to sort slicer values based on the numeric value in Power BI.

Furthermore, you may like some more Power BI tutorials: