Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Pin rows in table

Hello, I would like to pin the first two rows of the table; but when you click on the header the columns get out of order:

TOTAL AMERICA and CONTINENTE should always be at the beginning in that order.

 

when I click on growth, the order should only affect (NORTH AMERICA, CENTRAL AMERICA; ANTILLAS and SOUTH AMERICA), and I want TOTAL AMERICA and CONTINENTE to stay at the top

Regards,

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    I think the first thing you need to understand is that when you click on a column, all the other columns in Power BI Desktop are sorted with the column you clicked on.

    In Power BI Desktop, there is a close correlation between columns and rows. I have given an example.

    The need to write a DAX code on top of the original table to get the sorting situation you need can be met.

    Sort Order Column = 
SWITCH(
    TRUE(),
    'Table'[REGIONES] = "TOTAL AMERICA", 1,
    'Table'[REGIONES] = "CONTINENTE", 2,
    3 
)

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Anonymous I don't think there is a way to pin the rows. It might be possible with some disconnected tables but not straightforward forward and also that will be a matrix visual. 

  • Anand24's avatar
    Anand24
    Super User
    2 years ago

    Anonymous ,
    Like parry2k rightly said, this is not possible right now in Power BI visuals (both Table and Matrix). 
    As a work-around, you will need to create 2 tables and format in a way that it appears to be one. But again, you won't be able to sort all of them together with this work-around. This work-around will hold good if the table structure and sorting will remain same.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    I think the first thing you need to understand is that when you click on a column, all the other columns in Power BI Desktop are sorted with the column you clicked on.

    In Power BI Desktop, there is a close correlation between columns and rows. I have given an example.

    The need to write a DAX code on top of the original table to get the sorting situation you need can be met.

    Sort Order Column = 
SWITCH(
    TRUE(),
    'Table'[REGIONES] = "TOTAL AMERICA", 1,
    'Table'[REGIONES] = "CONTINENTE", 2,
    3 
)

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.