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!

     

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