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

[Anonymous]

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.

Thanks,

Mohan V.

[amitchandak]

@Anonymous , from three dots, are not able to sort on a the dynamic header.

Also, check this can help

https://www.youtube.com/watch?v=vlnx7QUVYME

[Anonymous]

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 · Accepted solution]

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