Forum Discussion

alanuxx's avatar
alanuxx
Frequent Visitor
3 years ago
Solved

Power BI Sort Hidden Row in Matrix

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.