Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Can sorting is possible where Dynamic header are implemented in Matrix Visual

Hello All, We have implemented Dynamic headers using metrix visual and it is working fine now.. But the issue is we are using measure. Can it be possible to sort if it is please suggest me.   Th...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Anonymous 

    I'm sorry, it can't sort  based on Net Revenu or else Ticket Sales or else DSD Class.

    You can only sort by real field ,such as "Description","Dynamic Ticket Sales"

     

    No matter which method is used to sort this matrix, in essence it is just to  sort the field  in the row of the matrix.

    You can change your matrix visual to table visual  and  sorting the whole measure in asc or desc.

    The field "description" will also be sorted  in table.

    Please pay attention to the  filed "description" in the table visual.
    ex: 

    （Please ignore the difference in field names）

    Then  reconverted into matrix. You will find the field "description " in matrix will sort based on the first occurrence of the value in field "description " in table visual .

     

    Best Regards,
    Community Support Team _ Eason

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Actually that is sorting the whole measure in asc or desc.

 

But what i am trying to know is, can i sort only based on Revenu or Sales or Class which appears to be different columns but not.

 

Something like that.

 

Any suggestions.

 

Thanks,

Mohan V.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , Anonymous 

    I'm sorry, it can't sort  based on Net Revenu or else Ticket Sales or else DSD Class.

    You can only sort by real field ,such as "Description","Dynamic Ticket Sales"

     

    No matter which method is used to sort this matrix, in essence it is just to  sort the field  in the row of the matrix.

    You can change your matrix visual to table visual  and  sorting the whole measure in asc or desc.

    The field "description" will also be sorted  in table.

    Please pay attention to the  filed "description" in the table visual.
    ex: 

    （Please ignore the difference in field names）

    Then  reconverted into matrix. You will find the field "description " in matrix will sort based on the first occurrence of the value in field "description " in table visual .

     

    Best Regards,
    Community Support Team _ Eason