Forum Discussion

bprakash's avatar
bprakash
Regular Visitor
8 years ago

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.  
Need Help
bprakash's avatar
bprakash
Regular Visitor
8 years ago

Hi v-yulgu-msft

 

Thanks so much.

 

Is there any workaround to sort individual columns of measure?

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi bprakash,

 

Currently, it is not achievable.

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

  • kn8e's avatar
    kn8e
    New Member
    4 years ago

    Anonymous said "There is no way of sorting a matrix visual by a column not being displayed."
    I found a way to not display my sort value because the the table in my matrix has a fixed number of lines. So I simply shrank the visual height to cause the bottom line to always be off the visual and thus it is sorted and not displayed. The only hangup is there is a vertical scroll bar on the far right that is always displayed.Sorted ColumnsHidden Sort Value