Tableau - Condition Filters


Advertisements

One of the important filtering options in Tableau is to apply some conditions to already existing filters. These conditions can be very simple like finding only those sales which are higher than a certain amount or it can be a complex one based on a certain formula. The conditions can also be applied to create a range filter.

Creating a Condition Filter

Using the Sample-superstore, let's find that sub-category of products across all segments whose sales exceed one million. To achieve this objective, following are the steps.

Step 1 − Drag the dimension segment and the measure Sales to the Column shelf. Next, drag the dimension Sub-Category to the Rows shelf. Choose the horizontal bar chart option. You will get the following chart.

condition filter 1

Step 2 − Drag the dimension Sub-Category to the Filters Shelf. Right-click to edit and go to the tab Condition. Here, choose the radio option by field. From the drop-down, select Sales, Sum and greater than equal to symbol specifying the value 100000.

condition filter 2

On completion of the above two steps, we get a chart which shows only those subcategory of products, which have the required amount of sale. Also this is shown for all the available segments where the condition is met.

condition filter 3

Useful Video Courses


Video

Tableau Online Training

Best Seller

88 Lectures 10 hours

Pavan Lalwani

Video

49 Charts in Tableau - (Latest Version)

64 Lectures 4 hours

Pavan Lalwani

Video

Visualising Data using Tableau

18 Lectures 1 hours

PARTHA MAJUMDAR

Video

Tableau Hands-on: Learn Data Visualization with Tableau

45 Lectures 5.5 hours

TELCOMA Global

Video

Master Data Visualization with Tableau

14 Lectures 53 mins

Harshit Srivastava

Video

Learn data visualization by tableau

40 Lectures 3.5 hours

Sanjeev

Advertisements