cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bprakash Frequent Visitor
Frequent Visitor

Sort by columns not working in matrix

In a matrix view, i used a measure in values for a report. In the report if i sort the report by this measure, this doesnot work. Pls help.

 

test.JPG

4 REPLIES 4
Microsoft v-yulgu-msft
Microsoft

Re: Sort by columns not working in matrix

Hi @bprakash,

 

In a Matrix, we can only change the order in row level.

 

Besides, when we sort the matrix by measure, the order is determined according to Total values rather than detailed records per column per row.

1.PNG

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bprakash Frequent Visitor
Frequent Visitor

Re: Sort by columns not working in matrix

Hi @v-yulgu-msft

 

Thanks so much.

 

Is there any workaround to sort individual columns of measure?

Microsoft v-yulgu-msft
Microsoft

Re: Sort by columns not working in matrix

Hi @bprakash,

 

Currently, it is not achievable.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
ahpitre Member
Member

Re: Sort by columns not working in matrix

I really like Power BI, but it seems that on such important items it still lags behind Tableau. This sorting issue while very important should be trivial in how it's done. I have tried all kinds of approaches and still there is no way of sorting a Matrix visual by a column not being displayed.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,537)