PowerBi – Sort the slicer selection in ascending or descending order

 PowerBi – Sort the slicer selection in ascending or descending order 

 
Right-click the calc group table > Create New > Data Column 

Set the Source Column property to “Ordinal” 

Set the Data Type property to “Integer / Whole Number (int64)” 

Optionally make the column Ordinal invisible (right-click / Make Invisible) 

Click the column of the corresponding calculation item 

Set the Sort By Column property to “Ordinal”