Hide Null Value in Filter But Keep in Calculation (Tableau)

 

Business Request:  Hide Null value in filter 'Downtime Type' but still keep it in calculation and show only 'Planned' and 'Unplanned'.  The reason is having Null value in the filter might be confusing for the users.

Solution:

    1)  Create a fake field to assign Null a different value that exists in the data set for field 'Downtime Type'.

        @Fake Field

        CASE [Downtime Type]

        When null then 'Planned'

        Else [Downtime Type]

        END

    2)  From this 'Fake Field', create a set 'Fake Field Set'

    3)  Create a 'Fake Field Set Filter' to be used as a filter

        @Fake Field Set Filter

        CASE [Downtime Type]

        When null then True

        Else [Downtime Type] in [Fake Field Set]

    4)  Drag @Fake Field Set Filter to filter shelf and select 'True'.  Use 'Fake Field Set' as a filter which should have only 2 values 'Planned' and 'Unplanned'.

Many thanks to Diego Martinez for help with the solution.