Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Table visual - Sorting by Region, Status

Hello All,   We have a Training Status Report in which we display region wise employee training completion status. Our client want this report should be sorted by region then status.   How ...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi Anonymous 

     

    you can try sorting two ways in Power query.

    step1: open power query sort the region by Asc.

     

     

     

    step2;  sort the status by asc again 

     

     

    Step3 : then add index 

     

    Step4: save and close

     

    then select your Region column > sort by column > index

     

    your table will be sorted based on you index values.

     

    I hope I answered your question!

     

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Anonymous 

 

I see this tread is quite old, but sorting a visual by one column and then a second column is as simple as clicking the 1st column header to sort ascending or decending. Then simply hold the <Shift> key down and click on the header of the second column.
Of course you can just keep the <Shift> pressed and click on a 3rd, 4th etc until happy.

 

I hope any one of my solution would help you!