Power BI Slicer Sort Descending [With Examples]

SharePoint Online training courses

Have you ever wanted to sort a Power BI slicer visual in descending order? Then This Power Bi tutorial will help you to sort a Power Bi slicer visual in descending order. And we will also cover the following headings.

  • Power BI slicer sort months in order
  • Power BI date slicer sort descending
  • Power BI slicer sort by month number

Power BI slicer sort descending

Let us see how to sort a slicer in descending order in the Power Bi report.

In this example, I have used the sales table data, to sort the slicer visual in descending order in Power Bi.

  • Open the Power Bi desktop and load the data using the get data option. Once the data has been loaded select the slicer visual from the visualization.
  • In the slicer visual drag and drop the Product Name field from the fields pane as below:
Power BI slicer sort descending
Power BI slicer sort descending
  • Click on the slicer and select the ellipses icon (…) in the top right-hand corner, and in the sorting option select the Z>A option to reverse the order of the sort (it will change from A>Z to Z>A)
  • By default, the slicer visually displays the value in ascending order. To sort the slicer in descending order choose the Z-A sort option.
  • In the below screenshot, you can see that the slicer visually displays the product names has been displayed in descending order.
Power BI slicer sort descending example
Power BI slicer sort descending example

This is how to sort a Power BI slicer in descending order.

Power BI slicer sort months in order

Let us see how to sort months slicer in descending order in a Power Bi report.

  • Open the Power Bi desktop and load the data using the get data option. Once the data has been loaded select the slicer visual from the visualization.
  • In the slicer visual drag and drop the order date month field from the fields pane as below:
Power BI slicer sort months in order
Power BI slicer sort months in order
  • Now click on the slicer and select the ellipses icon (…) in the top right-hand corner, in the sorting option select the Z>A to reverse the order of the sort (it will change from A>Z to Z>A)
  • By default, the slicer visually displays the value in ascending order. To sort the slicer in descending order choose the Z-A sort option.
  • The Screenshot below displays the slicer visual month value has been in descending order ( From December to January).
Power BI slicer sort months in order example
Power BI slicer sort months in order example

This is how we can sort months slicer in descending order in the Power Bi report.

Power BI date slicer sort descending

Let us see how to sort a date slicer in descending order in a Power Bi report.

  • Open the Power Bi desktop and load the data using the get data option. Once the data has been loaded select the slicer visual from the visualization.
  • In the slicer visual drag and drop the order date field from the fields pane as below:
Power BI date slicer sort descending
Power BI date slicer sort descending
  • Click on the slicer and select the ellipses icon (…) in the top right-hand corner, in the sorting option select the Z>A option to reverse the order of the sort (it will change from A>Z to Z>A)
  • By default, the slicer visually displays the value in ascending order. To sort the slicer in descending order choose the Z-A sort option.
  • In the below screenshot, you can see that the date slicer visually displays the date value in descending order ( from 2022 to 2019).
Power BI date slicer sort descending example
Power BI date slicer sort descending example

This is how we can sort date slicers in descending order in the Power Bi report.

Power BI slicer sort by month number

Here we will sort the month number in the slicer visual in descending order in a Power Bi report.

  • Open the Power Bi desktop and load the data using the get data option. Once the data has been loaded select the slicer visual from the visualization.
  • In the slicer visual drag and drop the order date month number field from the fields pane as below: Month number displays the value from 1 to 12.
Power BI slicer sort by month number
Power BI slicer sort by month number
  • click on the slicer and select the ellipses icon (…) in the top right-hand corner, in the sorting option select the Z>A option to reverse the order of the sort (it will change from A>Z to Z>A)
  • By default, the slicer visually displays the value in ascending order. To sort the slicer in descending order choose the Z-A sort option.
  • In the below screenshot, you can see that the date slicer visually displays the date value in descending order ( from 12 to 1).
Power BI slicer sort by month number example
Power BI slicer sort by month number example

This is how to sort the month number in the slicer visual in descending order in the Power Bi report.

This Power Bi tutorial explained how to sort a Power Bi slicer visual value in descending order. Also, cover the following headings.

  • Power BI slicer sort months in order
  • Power BI date slicer sort descending
  • Power BI slicer sort by month number

You may like the following power bi tutorials:

>