Friday 17 July 2015

How to set the filter value default to none ..

Sometimes we may have a requirement to show the blank sheet in the dashboard.
User will have to give the inputs in the filter and then accordingly display the reports in the dashboard.

These are the steps you need to follow..

1.Click on the filter
2.select customize 
3.deselect the show ALL option
4.change the filter to single drop down mode
5.you will see the default value present in the filter
6.Now Edit the filter
7. In the general tab you see all the values 
8.you will also see ALL , NONE tabs..
9.click on None tab and
10.click on OK
11.Now your filter shows the default value as None.

Enjoy..:)

6 comments:

  1. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.

    Tableau Online Training|
    SAS Online Training |
    R Programming Online Training|

    ReplyDelete
  2. Hey! Thanks for the tip, but I have a question: how can you achieve to keep showing none as default even when you change a first quickfilter? (if there are 2 filter)

    ReplyDelete
  3. Interesting. Did not not realise it was this simple. I thought I'll need to create a None value, select it and hide it etc. - thanks

    ReplyDelete
  4. I feel Tableau is the most useful and important aspect to solve complex IT problems and also find out solutions.

    Tableau Soap Connection

    ReplyDelete