Filter in row without affecting other rows

[Cristan]

Hello,

I want to filter through a data list, without affecting other rows.

I´ll try to illustrate the problem here:
As you can i see, i have a map on the left side, and a data list on the right.
I want to keep the map intact, when filtering through the list.

The effect can be seen here:

I want to make a note, that this is an example, since there are sensitive data in my original worksheet.
I also want to note, that the data list in my original document, has a dynamic filter function, and i want to be able to filter further, than the dynamic filter.

I hope it makes sense.

Best regard,
Christian

 

[Fluff]

I'm afraid you cannot do that, a row is either hidden or visible. You cannot hide just part of a row.

 

[sandy666]

you can try Power Query

green table will be always filtered but Query Table does not hide rows

this is just an idea not a copy/paste solution

 

[sandy666]

or use Pivot Table
then you can use filter as you wish without hiding rows

 

[Cristan]

Okay, thanks for your help! I'll check out the suggested solutions