Overview of Multiple Columns sort In power bi
In this blog, we will learn how we can sort a table using multiple columns for the table visualization in Power BI.
Here, first, we will learn how we can create and apply a sort for multiple columns. Then we will change the sort order for the column. Later on, we will also change the Sort Sequence for the table.
Topics:
- Create Multi-Column Sort for table
- Change Sort Order for Multi-Column Sort
- Change Sort Sequence for the table
- Limitations
We have a table called “Budget” in our Power BI report. We need functionality where we need to sort our table first on “Year” and then, “QTR” and “Month”.
So, now let’s get started!
Create a Multi-Column Sort Table
Step 1:
We want to first apply sort, on the following columns.
Year
Quater
Month
Press Shift + Left Click on the Header Column on which you wish to apply Multiple Sort.
Here, we will select the Quater Column with Shift + Left Click.
You can see here, first, it sorts the data based on the year and then it sorted data based on “Quater” column.
Step 2:
Now, let’s apply sort on the “Month” column.
To apply Sort on the “Month” column, Apply Shift + Click on the “Month” header column.
Change Sort Order and
Sort Sequence for the Multi Sort Column
Now, if we wish to change the Sort Order from Ascending to Descending, how can we achieve that requirement?
For that, apply Shift + Click on the same column where you have already applied sorting. This will also change the Sort Sequence.
Currently, as you can see in the below table our Sort Sequence is,
Quater > Month > Year
We wish to change the Sort Order for the “year” column, then apply Shift + Click for the “year” column.
This will change Sort Order from DESC to ASC. With this, it also changed the Sort Sequence as well.
Now, the Sort Sequence is,
Year > Quater > Month
Now, the Sort Sequence is,
Year > Month>Quater
Limitations of Multi-Column Sort
We can’t remove the Sort from the applied column.
This is limited to table visualization only. This multi sort feature is not applicable for Matrix visualization.
For any Help or Queries Contact us on info@crmonce.com or +919014146800
