cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kevjoh99
Helper I
Helper I

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?

 

Capture.PNG

 

Capture.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

Sort by Another Column.PNG

 

View solution in original post

11 REPLIES 11
Anonymous
Not applicable

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

 

Sort By Month Number.PNG

Hope this helps,

Nathan

Nathan,

 

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

 

Capture.PNG

Anonymous
Not applicable

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

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

Capture.PNG

Anonymous
Not applicable

I will give this a try.

Anonymous
Not applicable

You can get to the Modeling View with this icon:

Model View.PNG

 

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.

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...

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

Anonymous
Not applicable

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:

Sort by Another Column.PNG

 

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors