It’s common for Power BI users to sort their data set when they’re analyzing.
In this tutorial, we will learn how to sort descending in Power BI Slicer. I’ll also show you how to sort slicer values based on numeric values in Power BI and Power BI sort date slicer descending.
Additionally, we will learn how to do your custom order in the Power BI slicer.
Power BI Slicer Sort Order Descending
When we create a Power BI Slicer, you must see the slicer value is sorted in ascending order by default, but we can change it within four clicks.
Scenario:
Suppose you want to create a Power BI report with slicers for State, Product Category, and Month. However, if slicers are not sorted meaningfully, users will find it difficult to find and select the desired filter option quickly.
According to this scenario, we have a SharePoint list named USA Retail Sales Data that contains the following columns with various data types:
Follow the below steps to sort Power BI Slicer:
1. Open Power BI Desktop and load data using the Get data option. Then, you can see data in the Data pane.
2. Under the Home tab, select Visual gallery, and select the Slicer visual icon.
3. Using the +Add data option, add the Product Category into the Field.
4. Select the slicer and select the 3 dots (…) in the top right corner -> click Sort axis -> click Sort descending.
This way, you can sort the slicer in descending/ascending order in Power BI.
How to Sort Slicer Values Based on Numeric Values in Power BI?
To sort slicer values based on numeric values in Power BI, follow the example below:
1. Under the Home tab, select Visual gallery, and select the Slicer visual icon.
2. Using the +Add data option, add the Sales Revenue into the Field.
3. Select the slicer and select the 3 dots (…) in the top right corner -> click Sort axis -> click Sort descending.
This is how to sort a Power BI slicer in descending order.
Power BI Sort Date Slicer Descending
In this example we see how to sort date descending in Power BI Slicer.
Our dataset has a problem: there is no column for the date. Let’s check the steps below to learn how to sort it.
1. Go to the Table view. Under the Table tools, click New table.