Power BI Sort Hidden Row in Matrix

[alanuxx]

Hi Everyone ,

I need to sort index row which is hidden on matrix . First of all i have basic table as below. There is an index col combined by some columns .

I need to use Matrix instead of table as below .I removed index column from matrix, then  it has been sorted by Main product code alphabetically . But i want to sort by index col . Product2 should be first ,then PRODUCT2,PRODUCT0004 ,PRODUCT4

How can i sort by hidden row on a matrix ? 

Regards

[Anonymous · Accepted solution]

Hi @alanuxx ,

Can you add index columns in Power Query Editor? If could, it would be really easy.

1.Sory by INDEX_COL in it.

2.Group by MAIN_PRODUCT_CODE and add an index column.

3.Expand the tables, then group by SUB_PRODUCT_CODE and add an index column.

4.Now we get two sort columns. Go back to Power BI Desktop, sort SUB_PRODUCT_CODE and MAIN_PRODUCT_CODE by two index columns.

Expected result:

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.           

[Idrissshatila]

Hello @alanuxx ,

So, you click the three dots of the matrix then click sort by then click the column you want to sort by with.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[alanuxx]

My index col is not on the matrix.How can i choose this column?

[Idrissshatila]

Hello @alanuxx ,

then in the data view, go to the product column you're referencing in the matrix then click on it then click sort by column and click on index. this way the product your're viewing in matrix will be sorted by matrix.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[alanuxx]

i am getting from Tabular model .i sorted index column on tabular as well . But nothing changed.