Forum Discussion
Slicer On Multiple Values In One Column
I have a table that contains a number of columns, one of which is a description. Here's a sample of the values in the description column for various rows:
BLUE METAL SQUARE RED METAL SQUARE ORANGE CIRCLE YELLOW WOOD BLACK TRIANGLE GLASS GREEN DIAMOND GREEN WOOD SQUARE RED PLASTIC RED CIRCLE
I want a slicer that contains all of the possible attributes above, so it looks like this:
BLACK BLUE CIRCLE DIAMOND GLASS GREEN METAL ORANGE PLASTIC RED SQUARE TRIANGLE WOOD YELLOW
The idea is that if nothing is selected in the slicer, then the visual shows all rows in the table. But if anything is selected in the slicer, then the visual shows only those rows in which that attribute is present. So, if the user selected "SQUARE", the only rows shown would be those with the following values:
BLUE METAL SQUARE RED METAL SQUARE GREEN WOOD SQUARE
The user might then also select "METAL", in which case "GREEN WOOD SQUARE" would drop off the list, as it doesn't contain both selections.
I can't figure out how to do this - how to, in effect, have a slicer that says "If a particular field contains the selection, show it. If it doesn't, hide it".
27 Replies
- Ashish_Mathur
Super User
Hi,
One approach would be to Split the Description column by rows so that each word of each cell appears in a row of its own. Then we create another Table of unique entries from this Description column. We then create a relationship from the base data table to the table which has the unique entries.
- AnonymousNot applicable
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
- Ashish_Mathur
Super User
Hi,
Share some data, explain the question and show the expected result.
- vishy0501
Helper I
has this issue bee resolved