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.

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.