Pin rows in table

[Alexo3627]

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,

[Anonymous · Accepted solution]

Hi @Alexo3627 ,

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]

@Alexo3627 ,
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.

[parry2k]

@Alexo3627 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.