When we add data to Power BI, we can sort the data in ascending or descending order. But in this case, I want something different. The marketing team wants to see sales data grouped and ordered by Customer Location so they can quickly understand which locations are performing better.
To achieve this, we need to sort the Sales column based on Customer Location by using the Sort by Column functionality in Power BI Desktop.
In this Microsoft Power BI tutorial, we will see how to sort the slicer by another column in Power BI.
Sort Slicer by Another Column in Power BI
Let us see how to sort a slicer by another column within the same data table in the Power BI report.
In this example, I am creating a Power BI report using sales table data. From this table, I am using two columns: Customer Location and Sales. Customer Location will sort sales values.
To do this, follow the steps below:
- Open Power BI Desktop and load the data table using the Get Data option.
- Once the data has been loaded, choose the Table view.
- Please select the column you want to sort. In my case, this is sales.
- Then, under the Column tools, expand the sort by column and select the customer location:
- Now, in the Report section, select the Power BI slicer visual from the visualization and drag and drop the Customer Location field from the fields pane.
- In the same way, select the Line Chart visual and then drag and drop the Sales and Product names fields in it as below:
- Now, sort any values in the Power BI slicer visual; it filters and displays the sales data in the Line chart visual.
- The screenshot below shows the sales value chart for the selected customer location in the Power BI report.
In the same way, we can select different customer locations from the Power BI slicer visual, and it filters the sales value based on the selection.
This is how to sort a slicer by another column within the same data table in a Power BI report.
You may like the following Power BI tutorials:
- Remove Leading Zeros in Power BI
- Add Hyperlink to a Text Column in Power BI
- Power BI Date slicer only shows dates with data
- Power BI Date Slicer By Month
- Add a Dropdown Slicer in Power BI
Hey! I’m Bijay Kumar, founder of SPGuides.com and a Microsoft Business Applications MVP (Power Automate, Power Apps). I launched this site in 2020 because I truly enjoy working with SharePoint, Power Platform, and SharePoint Framework (SPFx), and wanted to share that passion through step-by-step tutorials, guides, and training videos. My mission is to help you learn these technologies so you can utilize SharePoint, enhance productivity, and potentially build business solutions along the way.
