Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Matrix Table- Column Header Custom Sorting and Sorting of Either Number or Percentage Column

Hello Members,   I need assistance in below mentioned requirements and my Data Source is SSAS:   Firstly, I need to list the column header based on particular custom sequence without having to sh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

You can create a new table which contains the sorting.

For example, by default, he sorts by number size, I want to customize a sequence, you can do it as follows.

Create a new table.

Sort text column by sort column.

Create a relationship and in general, it is one-to-many.

Replace the text column with the new table, and you will get the result of the custom sort.

Sort a Column with a Custom Order in Power BI - RADACAD

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Stephan,

 

I am using direct query and hence on power bi file everything is disabled. I need solution that can be implemnetd on SSAS side. However appreciate your help.

 

Let me know if there's anything that can be done on cube side which meets my requirement.

 

Also, I am talking about matrix visual in here which doesn't let you sort like the way it is in Table visual.

 

Thanks,