Autofilling slicer off a different slicer's input

[ajmonster]

Hello

I'm looking to have Slicer B autofilled based off of Slicer A's input. In practice, I can enter a Store ID into Slicer A and based off of that input Slicer B will autofill with the Market ID. In addition, I would like the report to be filtered not by Slicer A but instead just by Slicer B (Market ID).

So far, I haven't come across any custom visuals from the store. Any help would be appreciated.

Thanks,

ajmonster

[vcastello · Accepted solution]

Hi @ajmonster

You can have Slicer B filterd by the value of Slicer A. And you can have the visual filtered only by the value of Slicer B

for doing it you need ...

1.- Create a filter visual with the field Store ID in it. Visual A
2.- Creat a filter visual with the Market ID in it. Visual B.

3.- Create the visual with the info you need filtered. The visual that suits your needs. This will be Visual C.

4.- Click on Format - Edit interactions.

5.- Clck on Visual A.

6.- You will see how the rest of visuals display a couple of icons on the right. If you click on the filter icon on the Visual B, this will filter the values of that visual in function of the selection of Visual A.

7.- If you click on the 'forbid' icon on visual C it will forbid any interaction in between both visuals.

8. - If you select the Visual B (not on the icons side) and then you click on the filter icon on the Visual C, you will have that visual filtered by the value of Visual B.

Hope That Helps

[ajmonster]

Thanks for the solution @vcastello. I don't think the two extra clicks will be a problem.