Forum Discussion
Anonymous
7 years agoNot applicable
Matrix Custom Sort
I am unable to figure out how to sort this matrix based on the date ranges below. I have tried a custom sort but that did not seem to work. Any ideas?
- Anonymous7 years ago
You could use the "Sort by Column" icon (just select the field you want to sort first):
Or, click the 3rd icon on the left:
11 Replies
- AnonymousNot applicable
On the Modeling View, in the field list, select Range, then set the Sort by Column to the Index.
Hope this helps,
Nathan
- AnonymousNot applicable
Nathan,
I'm not sure how you got to that screen.
- AnonymousNot applicable
Your date ranges are all in the "value" section of the matrix correct?
- AnonymousNot applicable
No, I am trying to get a count of Service Calls within a certain range, 0-30, 31-60.....
- AnonymousNot applicable
I believe this is a similar issue to yours.
https://community.powerbi.com/t5/Desktop/Filtering-matrix-rows-by-a-column-value/td-p/225092