Forum Discussion
Custom Order in hierachical matrix visual
Hi Chennakesava458 ,
Base on my research, there is no option to set the row columns in reverse order. There is an workaround can be achieve the similar requirement. You can find the details in the attachment.
1. Create a sort order table
RowName SortOrder employee1 1 employee2 2 Manager1 3 employee2 4 employee4 5 Manager2 6 Client1 7 2. Create a measure as below
Measure = var _gl=SELECTEDVALUE('Sort Order'[RowName]) RETURN CALCULATE(SUM('Table'[Sales]),'Table'[GL-4]=_gl||'Table'[GL-3]=_gl||'Table'[GL-2]=_gl)Best Regards
Hi Team,
Based on below sample data
GL-2 GL-3 GL-4 Sales
| employee1 | Manager1 | Client1 | 1500 |
| employee2 | Manager2 | Client1 | 2500 |
| employee2 | Manager1 | Client1 | 4000 |
| employee4 | Manager2 | Client1 | 6800 |
if we create Matrix visual
But my requiremnt is
employee1 1500
employee2 4000
Manager1 5500
employee2 2500
employee4 6800
Manager2 9300
Client1 14800
Anybody Suggest how to achieve this
Hi Chennakesava458 ,
Base on my research, there is no option to set the row columns in reverse order. There is an workaround can be achieve the similar requirement. You can find the details in the attachment.
1. Create a sort order table
| RowName | SortOrder |
| employee1 | 1 |
| employee2 | 2 |
| Manager1 | 3 |
| employee2 | 4 |
| employee4 | 5 |
| Manager2 | 6 |
| Client1 | 7 |
2. Create a measure as below
Measure = var _gl=SELECTEDVALUE('Sort Order'[RowName])
RETURN CALCULATE(SUM('Table'[Sales]),'Table'[GL-4]=_gl||'Table'[GL-3]=_gl||'Table'[GL-2]=_gl)
Best Regards