Forum Discussion
Power BI Sort Hidden Row in Matrix
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.
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 👍
My index col is not on the matrix.How can i choose this column?
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 👍
i am getting from Tabular model .i sorted index column on tabular as well . But nothing changed.