Forum Discussion
Helper IIHow to Filter a Table without Losing Information from other columns
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 |
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.
3 Replies
ExcelMonkeImpactful Individual
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.
- Ashish_Mathur
Super User
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.