Forum Discussion

Budfudder's avatar
Budfudder
Icon for Helper IV rankHelper IV
7 years ago

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

  • 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.

    • Anonymous's avatar
      Anonymous
      Not 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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User

        Hi,

        Share some data, explain the question and show the expected result.