Shawn! This is great!! Thanks so much for sharing--I never knew about this trick!

thank Shawn... nice trick

Shawn nice trick and thanks for sharing i didn't knew this option exist to define  filter selection

---Bhujang

Thanks a lot Shawn, it's a really nice trick and exactly what I was looking for.

Just one question though... When "(All)" is selected on the quick filter, the image of one of the products is displayed, while this is not the case for products not having any image assigned.

Any idea how to solve this?

Thanks,

Amandine

Thanks for your quick reply, Shawn.

Unfortunately I need the ALL option to be available.

On my dashboard, my list of products contains individual products (camomille, mocca, etc...) but also products which are grouped together, for example something like "sold out beverages" for which I do not have a picture since it is several products altogether. But this actually works without any problem. When I select one of these products, no picture shows up and it is fine.

The only problem is that I need to be able to show as well all products together on this dashboard. And when I do so by using the ALL option, it displays the picture of one of the individual products, while I would like to have no picture instead.

And I do not really understand why this is the case or how the picture is selected.

Do you think that there is another trick to get around this issue? :-)

Thank you in advance and have a nice weekend,

Amandine

Amandine,

One thing you might try is creating a calculated filed with Size() as the calculation.  Place that on Filters and select "At Most 1".  Make sure it is computed along Product.  That way, when you have a single product selected, the Size is 1 and the image is shown.  When you select "All" the Size() is more than 1 and nothing is shown.

Regards,

Joshua

Nice one, Josh!

Shawn, here's a way to find out when All is selected: Identifying (and Using) Quick Filter Selection Status | Drawing with Numbers. The basic process is to use a self-blend that is not filtered, so you always have a source of truth to know how big "All" is, then you use a calculated field to test for that.

Dear all,

thank you very much for your help. It works exactly as intended now, using your different suggestions and tricks.

Many thanks :-)

Amandine

Hi Shawn,

I used the same method as you to put Powerpoint slides into Tableau to get a slideshow :-)

Ville

Shawn,

this is great! Works perfectly if I use it offline. As I'm using tableau public 8.1 I want to use this trick especially online. In this case no pictures are displayed at all. Any idea what the problem could be? Any settings that must be considered?

I used a filter-action an the dashboard instead of a quick-filter:
Workbook: WIP_Stadtteile

Thanks,

Chris

... solved the problem. You shouldn't use German 'Umlaute' (like ä, ö,ü or such) in the file-path.