Using slicers but needing to reverse engineer it

[datadelta]

I currenlty have a report where I'm using a slicer for a lot of POS shops.  I have the slicer tied to a funnel and that works great.

The problem is that I need to make it easier to click on the item of sale in the funnel and have it highlight who sold the item.

So, choose the item say, "Umbrella" and it brings back which stores sold the umbrella rather than hunting and pecking in the slicer.

Any ideas?  I feel like this is easy but for some reason I cannot solve.

Thanks.

[PaulDBrown · Accepted solution]

Your best option is probably to create a report page tooltip:

...or create a visual listing the stores and if you click on a product it will filter the visual to show the relevant stores (but you will have to disable the interactions between the visual and the slicer).

[datadelta]

Okay I created it but the tooltip just shows all POS's and not just those that sold the item.

[PaulDBrown]

Can you share a dummy PBIX file using OneDrive, Dropbox, Google Drive...?

[datadelta]

I'll put that together and share.  Thank you.