How to Filter a Table without Losing Information from other columns

[DMB90]

I have a table with different names for Fieldwork, Level 1 Reviewer and Level 2 Reviewer based on each assignment. Right now when I use the name slicer to filter for a name (i.e., Tim), then the other names on that row disappear. Is there a way to use the slicer to filter for a name, but all the other names on the row remain? 

Fieldwork	Level 1 Reviewer	Level 2 Reviewer
Sally	Tim	Kelly
Tim	Christian	Matt
Christian	Sally	Matt

[Ashish_Mathur · Accepted solution]

Hi,

Not sure of what you are trying to do.  In Power Query, insert an Index column.  Select the Index column, right click and select "Unpivot Other Columns".  Click on Close and Apply.  Now apply the filter.

Hope this helps.

[ExcelMonke]

Hello,
It depends on what exactly you're trying to achieve. What are you wanting to filter out (/in) with your slicer? It is a bit unclear on what you are hoping to achieve by using a slicer without it slicing your tables. Any additional info would be helpful! 🙂 

[DMB90]

For example, if I wanted to select Tim from a slicer. I want all rows with Tim's name to remain, but I still want to be able to see the other names on all rows with Tim's name. If I filtered for Tim currently, the rows with just his name would appear and I would not know the other names on the rows as they disappear.