Skip to content
  • YouTube
  • FaceBook
  • Twitter
  • Instagram

Data Analytics Ireland

Data Analytics and Video Tutorials

  • Home
  • Contact
  • About Us
    • Latest
    • Write for us
    • Learn more information about our website
  • Useful Links
  • Glossary
  • All Categories
  • Faq
  • Livestream
  • Toggle search form
  • Create a HTML Table From Python Using Javascript Javascript
  • How to connect to your data in Tableau data visualisation
  • How to Create Multiple XML Files From Excel With Python Python
  • Python Overview Interview Questions automation
  • How to import data into excel Python Tutorial
  • TypeError: ‘str’ object is not callable Python Functions
  • how to create and drop a table in SQL SQL
  • Explain different types of data Normalization. SQL

How can I filter my data in Tableau?

Posted on May 26, 2021June 29, 2021 By admin

Estimated reading time: 5 minutes

Tableau has some very powerful ways to manage your data through dimensions and measures.

Once you are happy how your data is structured, you will then need to filter your data. Here we talk you through the process and how you can use it to your advantage.

So why would I want to apply a filter?

This is probably the first question you should ask, and there are a umber of reasons:

(A) You have a large volume of data, you only want to see a section of it.

(B) You are building several versions of a report, a filter will allow you create those reports with the data specific to each.

(C) You maybe providing information within Tableau, but you may not want people to see certain information, so you just filter that out.

(D) Filters can also let you see problem data, which when found can be checked. In essence, you could use it as part of your data quality strategy within the organisation.

So how can I apply a filter?

There are a number of ways:

(A) On the data source tab within your project. This option is always available but sometimes forgotten about as other ways can be used, specifically on any sheet.

(B) When you are on your sheet tab, a filter can be applied as follows:

  • Drag a dimension or measure to the filter area:
  • If you have dragged a measure or dimension to the columns section, then just click the down arrow and then filter:

What are the types of filter I can apply?

The filter for dimensions is different to measures, below we will describe each.

Dimension filters:

  • General – This allows you to pick values that you want, one or a combination from the list is what is offered.
  • Wildcard allows you to put in values that are not in your list but can be searched for to see if any of the data contains them.
    • For example, on the below, we are asking the filter to only return any values in the Gender column that include “Fem”. So this would then exclude all the male values.
    • There are several different ways to approach this, as can be seen below.
  • Condition – Here they allow you to apply certain logic that must be met, based on the condition entered. This will only return values where the condition is met.
    • Note in dimensions, you only have the four options below
  • Top – Here we literally return the top no of records based on the conditions you apply.
  • Also you could complete by putting in a formula, using one of the other dimensions.

Measure filters:

Measure filters are quite intuitive as they allow you to define the parameters that the filters will be applied on.

As measures are numerical based, they will involve you telling the program what range or value to filter on.

Below are some examples:

data visualisation, Tableau Tags:data source, filter data, tableau dimensions, Tableau filter, tableau measures

Post navigation

Previous Post: What are measures in Tableau?
Next Post: How to Compare Column Headers in CSV to a List in Python

Related Posts

  • What are measures in Tableau? data visualisation
  • What are dimensions in Tableau? data visualisation
  • How to connect to your data in Tableau data visualisation
  • Tableau Desktop versus Tableau Server data visualisation
  • How to create a calculated field in Tableau data visualisation
  • How to group your data in Tableau data visualisation

Select your language!

  • हिंदी
  • Español
  • Português
  • Français
  • Italiano
  • Deutsch
  • Python Tutorial: How to validate data using tuples Python Tuples
  • What does a data analyst do? Livestream
  • how to update records in SQL CRUD
  • What are the reserved keywords in Python Definition
  • What is Visual Studio Code? Visual Studio
  • Free ways to Extract Data from Files Livestream
  • How To Create An Empty Dictionary In Python python dictionaries
  • What is Jupyter notebook? Jupyter Notebook

Copyright © 2023 Data Analytics Ireland.

Powered by PressBook Premium theme

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT