Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

sort rows in a matrix with multiple row headers and column headers

Hi experts,

I have a power bi matrix with 3 row headers (type>plalnt>product) and 2 column headers (category>month) like this:

here i only show one category "sales prices", there are other 2 categories ("performance variable" and "performance full"). each have data for all 7 months. there are 29 products in total.

 

i didn't find a way to sort the 29 rows based on the data of "performance variable" in the first Month of each product.it seems with the current order of row headers (first type then plant and last product), it is impossible to sort rows by products' variable performance in the first month.

what's more, the seven months u see in the matrix are not fixed, they are changing per version. in the next version the months will be from Sep till March of the next year. and then i need to sort the column by the data of products' performance variable in Sep (the first month).

 

Currently, what i am doing is to put products as the first row header in the matrix (product>type>plant). and then in a table,  add a column which only contains the values of products' variable perfromance in the first month, so i can sort [product] column by the new column. and finally in the matrix, i can sort it descending by products:

 

 May i ask, if i want to keep the row headers as TYPE>PLANT>PRODUCT, how can i still get the same product row orders?

can anyone help me this? 

Thanks in advance!

 

1 Reply