Forum Discussion
Sort by another column error : "We cannot sort the "foo" column by "bar"
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.
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?
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