tableau-desktoptableau-cloud

Tableau - have a chart with data which is not included in filter


Using tableau cloud/desktop, how do you add a chart in a dashboard which has the opposite of your dashboard filters?

I am trying to get two charts on my dashboard: one showing the data filtered by my dashboard filters, and one with the opposite (the remaining data)


Solution

  • You can use parameters and sets controls to get your users choices (instead of filters) and then create a boolean calculated field, say called [Show_Data?] that reads those parameters and tests those sets for your filter criteria.

    Then your solution is easy, just filter on [Show_Data?] = TRUE on one viz, and [Show_Data?] = FALSE on the other.