Forum Discussion
Slicer On Multiple Values In One Column
Hi Ashish_Mathur,
I am facing the same issue as the this thread. Can you please explain further what you mean by your approach? I would like to test this out for my data.
Thank you.
Christiana
Hi,
Share some data, explain the question and show the expected result.
Hi Ashish_Mathur,
I would like one slicer to display the following list of values:
Matt Chirgwin
Sam Mackay
Alex MeyersMarcelle Ahamefule
Cameron Hensley
Mandy Sandhu
From the coloumn below:
1 Matt Chirgwin 2 Sam Mackay, Marcelle Ahamefule, Alex Meyers, Cameron Hasley 3 Alex Meyers, Marcelle Ahamefule 4 Marcelle Ahamefule, Cameron Hensley 5 Matt Chirgwin 6 Matt Chirgwin, Mandy Sandhu The point is to draw the name once into the slicer which captures every time the name appears in the column i.e Marcelle Ahamefule will capture rows 2, 3 and 4, Matt Chirgwin will capture rows 1, 5 and 6. At the same time Cameron Hensley will capture rows 2 and 4. The same concept should apply to all the values. The list I am working with is a very long one with some rows with 4 to 5 names. The steps provided earlier only works for the first name on the list - I have already played around with this concept.
Ideally, this should work as new names are added. Automatically.
Thank you.
Christiana
Hi,
In the Query Editor, reference the original table and remove all columns other than the Name column. Split the column by delimiter >Comma and under Advanced Options, select Rows. Remove Duplicates.
Hope this helps.
Hi Ashish_Mathur,
Thank you. This will work if I can apply the same with multiple columns. I mean the index numbers need to match the names in the rows. When I split them by row the names lose th relationship with the column/rows. Is there a way?
1 Matt Chirgwin 2 Sam Mackay, Marcelle Ahamefule, Alex Meyers, Cameron Hasley 3 Alex Meyers, Marcelle Ahamefule 4 Marcelle Ahamefule, Cameron Hensley 5 Matt Chirgwin 6 Matt Chirgwin, Mandy Sandhu Thank you.