March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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.
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 👍
Follow me on Linkedin
Vote For my Idea 💡
Proud to be a Super User! | |
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 👍
Follow me on Linkedin
Vote For my Idea 💡
Proud to be a Super User! | |
i am getting from Tabular model .i sorted index column on tabular as well . But nothing changed.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
83 | |
76 | |
62 | |
58 |
User | Count |
---|---|
141 | |
122 | |
105 | |
94 | |
90 |