Power BI Table visual - Sorting by Region, Status

[Anonymous]

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

[Uzi2019]

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!

[Uzi2019 · Accepted solution]

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]

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]

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