Are you publishing this workbook or distributing as is?
It is possible to remove the "All" option in filters (this can be found the options when you show the quick filter under Customize)
It is also possible to set a filter to use "None"... if you drag your field onto filter, you can choose none.
If you set all your filters to use none and not have the All button, and make them "Show Relevant Values" (also in the quick filter options), then users will have to specifically click each filter to make data appear.
Would that work for you?
Thanks for taking your time out for replying. I will be distributing workbook
I have taken off "All" from all the cascading filters and selected "None" in all filters also made it "Show Relevant Values". But the end result is filters not showing anything.
Sample workbook is uploaded here. Please help.
Many thanks again for responding.
Sorry I should probably have mentioned that the first filter you want people to click should not be set to relevant values.
If I have a moment I'll look at your workbook as well and have a play
Hope that helps already!
I have set first filter to "All values in database" and other filters as relevant but the end result is not desired.
I have created one similar to my requirement using context filters and link for same is -
Using the same solution for my problem is not working since my data is >5millions and creating context filter on the table is time consuming.
I see it does not work.
I've had a play with your sample workbook, but I don't really see a good solution for the quick filters situation. I think the only way I would know how to build this is to use a dashboard with actions.
I'll try and attach a sample workbook when attachments are allowed again.
Hope that helps,
If action filter can show blank values or blank sheet until last cascading filter is selected, that would perfectly fit my requirement. Kindly post workbook if you are able to achieve the result.
Sorry for bugging again and again, am pretty much new to Tableau and this is a requirement from the client.
Thanks for your time again - Dana
No problem at all! This is how you get started - everyone does. And getting it just ight is the fun of answering questions in the forum
I can get it to work properly on my Tableau Desktop. Do you have desktop as well or just Tableau Public?
I'll keep an eye on attachment rules and attach when possible.
I work on Tableau desktop
1 of 1 people found this helpful
I thik you can do this using the SIZE() function. I've had no time to look at this properly or write a full explanation (I'll try do so some time shortly...) so I've attached your workbook with an example.
Quick summary - create a calculated field Size with the function SIZE(). Drag City to the level of detail. Drag Size to the filters and Compute Using City. Set the filter to Most of 1. That's saying only show data if only 1 city is selected.
Gosh sorry I completely forgot to attach the workbook I did for you.
I've not had a look at Andrews work with the index() function, but I'll attach what I've done anyway - this way you'll have alternatives
Dana & Andrew,
Thanks a lot for your support, both your answers were working for my case.
Your provided solution worked when last filter I had in the cascading was a dimension (City), but what if my last filter is a measure (cust_id) and i want filters to display data only when and if cust_id is selected.
Dragging the cust_id to the detail marks gives random view to the dashboard, thereby am unable to use your solution in this case.
Any workaround for this you might come up in this scenario?
Thanks for your time again!
Hi i am getting the proper date why you are not getting i don't know
can you please share the query clearly...