In this Microsoft Power Bi tutorial, we will see how to sort slicer by another column in Power Bi.
Power Bi sort slicer by another column
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 going to create a Power BI report using the sales table data. We will select two columns called customer location and sales from the data table, and we will sort the sales value based on the customer location.
- Open the Power Bi desktop, and load the data table into it using the get data option. Once the data has been loaded, Choose the data section and select the sales column as below:
- Under the Column tools, expand the sort by column and select the customer location column as below: It automatically works on it.
- 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 from the Power Bi slicers visual, it filters and displays the sales data in the Line chart visual.
- The below screenshot displays the chart sales value based on the selected customer location in the Power Bi report.
In the same way, we can select different customer location 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.
This Microsoft Power Bi article illustrated how to sort slicer values by a different column in a Power Bi report.
You may like the following Power BI tutorials:
- Power BI Slicer Sort Descending
- Power BI Date slicer only shows dates with data
- Power BI Date Slicer By Month
- How to Add a Dropdown Slicer in Power BI
- How to remove Date Hierarchy in Power BI
I am Bijay a Microsoft MVP (10 times – My MVP Profile) in SharePoint and have more than 17 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com