Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not 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?

 

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

Anonymous
Not applicable

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? 

Anonymous
Not applicable

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

Capture.PNG

Anonymous
Not applicable

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

 

Anonymous
Not applicable

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

Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.