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
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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.

 

Regards,

Yuliana Gu

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