cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Sorting Matrix Table Values

In Matix visual, how can keep "Account Type" sorted not alphabeticly, but based on GL account #?

I tried sorting based on column, but no luck. 

 

 

 

In the example below is Quickbooksonline out of the box model, I just selected "Account Type".

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

You can use the "Sort By Column" functionality to accomplish this. Click on the Data tab, highlight the row, select the Modeling tab, then "Sort By Column". This will allow you to sort by a different column, such as Account Number.

 

SortMatrix.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks,
Sam Lester (MSFT)

 

 

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

You can use the "Sort By Column" functionality to accomplish this. Click on the Data tab, highlight the row, select the Modeling tab, then "Sort By Column". This will allow you to sort by a different column, such as Account Number.

 

SortMatrix.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks,
Sam Lester (MSFT)

 

 

View solution in original post

Highlighted
Anonymous
Not applicable

hello!

 

is there a way to have a 2-step sorting scheme?

 

I have a table and the first filter has to be on a measure I created, then considering that many of that is 100%, I would like to sort the table according to another variable, which is not a measure.

 

Thanks in advance for helping.

 

Regards,

Andrea

Highlighted

Shouldn't the instructions read " ... Click on the Data tab, highlight the row column ..."?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors