Matrix Custom Sort

[Anonymous]

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?

[Anonymous]

On the Modeling View, in the field list, select Range, then set the Sort by Column to the Index.

Hope this helps,

Nathan

[Anonymous]

Nathan,

I'm not sure how you got to that screen.

[Anonymous]

Your date ranges are all in the "value" section of the matrix correct? 

[Anonymous]

No, I am trying to get a count of Service Calls within a certain range, 0-30, 31-60.....

[Anonymous]

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

[Anonymous]

I will give this a try.

[Anonymous]

You can get to the Modeling View with this icon:

[Anonymous]

OK, I belive I know why I do not see that icon, it's because I am using a version optimized to allow me to save to our Power BI Report Server.

[garythomann]

The Matrix visual lacks functionality.  There are lots of ideas on the community site.  Below are the front runners.  Please vote these up!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-s...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-f...

[Anonymous]

I must have an older version as I do not have that icon.

[Anonymous · Accepted solution]

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: