Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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".
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |