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 to achieve it.

Thanks,

PBI V2

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!

     

4 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    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!

     

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Anonymous -

    In table chart select it. In table chart itself you can sort by selecting the "Region" from the first dropdown as per below snapshot.
    Then, click on select the status column column tools it choose the field status sort.

     

     

     

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello rajendraongole1 ,

       

      Thanks for your response. We tried the option suggested by you but I am not able to sort Status completely. Below is the screenshot:

       

      Actually, this report contains around 800-900 records and our client want report should display data

      Region wise first then under Region, Status should be sorted.

      e.g. 

      1) Region should be sorted so "East" will come first alphabetically.

      2) Under region "East", all the "Complete" status should come first then "In Progress" then "Overdue"

       

      Thanks,

      PBI V2

  • 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!