Forum Discussion
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 in the A slicer. For example, if "3" is selected in A, I want "X," "Z," and "T" to be automatically selected in B, and the filtering should be based on this selection.
How can I do it?
8 Replies
- marcelsmaglhaes
Super User
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!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
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.
