HI, I have created a matrix.below screenshot is the matrix i have created.i have 2 questions associated with it. Q1. The row lable i need it in this order(>80%, 70%-80%, 60%-70%, 50%-60% & <25%) Q2. I need to display the column in this order Q1, Q2, Q3, Q4, Q1_WK_01, Q1_WK,02.....Q1_WK13, Q2_WK_01.... Is there a way of doing this? Thank you Regards,Sandeep

Anonymous Just create dimension with those labels and column which wil determine the sort order (values 1, 2, 3 etc.). Create relationship between dimension and facts, if it is not active yet, and you're done :smileywink: Regards.Pavel

arrange matrix rows and column | Microsoft Fabric Community

8 Replies

Baskar
Resident Rockstar
9 years ago
Cool,

For this u have to create two column, for shorting order
example :
column = switch ( column_name,
">80%", 1,
">90%", 2,
.... etc
)

using this column u short the original dimension column.

try this , let know if any help.
- Anonymous
  Not applicable
  9 years ago
  Baskar PavelR
  
  I created a new colum and tried sorting my original column based on this new column.I get the below error
  
  I have created the original column based on the below formula.Is that creating problems?
  
  Thanks for your time.
  
  Regards,
  Sandeep
  - PavelR
    Solution Specialist
    9 years ago
    Anonymous Just create dimension with those labels and column which wil determine the sort order (values 1, 2, 3 etc.). Create relationship between dimension and facts, if it is not active yet, and you're done :smileywink:
    
    Regards.
    Pavel
PavelR
Solution Specialist
9 years ago
Hi Anonymous

I would recommend adding Sort column (values 1, 2, 3 etc.) to your dimensions, and on the relevant columns just use "Sort by column" and add you Sort column.

Regards.
Pavel
v-yulgu-msft
Microsoft Employee
9 years ago
Hi Anonymous,

As PaveIr mentioned, the thread to customsize sort matrix rows and column is dding Sort column (values 1, 2, 3 etc.) to your dimensions, and change the default sort column (itself) to Sort Column under "Sort by column".

The error message means you can't sort by a column that depends on the column you want sorted. To work around this issue, please create the Sort Column in Query Editor. Go to Edit Queries, under the Add Column tab, select Conditional Column. You can use this method to create both columns [Lable] and [Sort Column].

For more details, please refer to KGrice's reply in this link: Sort by another column error

Thanks,
Yuliana Gu
- Anonymous
  Not applicable
  9 years ago
  v-yulgu-msft PavelR Baskar
  
  Issue Resolved.
  
  Thanks you guys for your support , resolution & time.
  
  Regards,
  Sandeep