Sort by another column error : "We cannot sort the "foo" column by "bar"

[jsnadams]

I keep hitting this issue trying to sort by another column, where I have many incidents that occur in a single day, my goal is to sort the table first by calendar day, then by the incidents, in the order of most incients counts to least incident counts;

Sample Data;

Date	Incidents	IncidentCount
11/8/2016	IncidentA	5
11/8/2016	IncidentB	50
11/8/2016	IncidentC	3
11/7/2016	IncidentD	100
11/7/2016	IncidentE	5
11/7/2016	IncidentF	70

This is the output I would like:

Date	Incidents	IncidentCount
11/8/2016	IncidentB	50
11/8/2016	IncidentA	5
11/8/2016	IncidentC	3
11/7/2016	IncidentD	100
11/7/2016	IncidentF	70
11/7/2016	IncidentE	5

But I keep getting this error when I sort by another column:

"Sort by Another Column Error"  "We cannot sort the "foo" column by "bar".  You can't have more that one value in "foo" for the same value in "bar".  Choose a different column for sorting or update the data in "bar".

[BhaveshPatel]

You can use the matrix visualization to see the sorting by the calendar day and Incident Count.

Alternatively, You can also create a third calculated column to combine the two columns using CONCATENATE and do the sorting by that column.

[jsnadams]

Thanks you for your response, but that is what I tried to do, but notice the Date column gets re-sorted, where I need to see most current date at the top, then I need to see IncidentCount sorted, my example I used Excel to do this (first sort one column, then sort a 2nd column), so I am hoping there is a way to also do this in Power BI?

[v-shex-msft]

Hi @jsnadams,

Currently, power bi visuals not support multiple columns sort, since others has already post this request, you can vote at below link:

Add a multiple columns sort featue

Regards

Xiaoxin Sheng