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 orde...
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.

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.