Forum Discussion

Bkurtsatar's avatar
Bkurtsatar
Frequent Visitor
2 years ago

AutoSelected By Other Slicer

Hello, I have a slicer for a column in table A, and I also have a slicer for another column in table B. I want certain values in the B slicer to be automatically selected based on the value selected...
Need Help
marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
2 years ago

Bkurtsatar ,

Is there a relationship between tables A and B? Because if you have a relationship, in theory, slicers should work exactly how you need them to. If you don't have a relationship, well, you're going to need one!

Bkurtsatar's avatar
Bkurtsatar
Frequent Visitor
2 years ago

Thank you for the response. There is no relationship between the two tables, and there is no common column where a relationship could be established.

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    2 years ago

    Hello Bkurtsatar ,

     

    yuou need to create a column in B table to specifiy every value to each number it references in table A, then link this new column with the A column.

     

    in this wayy you can filter from A table.

    • Bkurtsatar's avatar
      Bkurtsatar
      Frequent Visitor
      2 years ago

      But it's not limited to a single value. So how can I add "X," "Y," "Z" values for the "3" value in a single column? Table B, where X, Y, Z values are, is a static table.

      • marcelsmaglhaes's avatar
        marcelsmaglhaes
        Icon for Super User rankSuper User
        2 years ago

        You need something like that