EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Tableau Parameter Filter
Secondary Sidebar
Tableau Tutorial
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Interview Questions
    • Tableau Interview Questions

Tableau Parameter Filter

By Priya PedamkarPriya Pedamkar

Tableau-Parameter-Filter

Introduction to Tableau Parameter Filter

The parameter is the dynamic value that we can change in the chart or bar graph. The parameter can be anything like text, range of values. Some visualization options are not available into a visualization for the data, with the help of parameter filter we can create values for better visualizations. We can create a parameter with field-based value but if field changes then parameter values do not change. Parameter keeps old values only. We can use a parameter with the filters or with the sets. As the parameter is a dynamic value, it changes the constant value in the calculation or reference lines. We can make parameters more dynamic with parameter actions. In this topic, we are going to learn about Tableau Parameter Filter.

Syntax

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Filter ->TOP->By field->select default value or create new parameter.

How does the parameter filter done in Tableau?

Whatever parameter value we select or add in the parameter, the result is displayed to the user. We have to select a range of values like 10, 20 or any number till we want to fetch the result.

The result is changed dynamically due to the parameter.

Examples of Tableau Parameter Filter

We are going to create a chart as per the top 20 sales as per the product name.

  1. Open Tableau public or desktop version.
  2. Connect to the sample superstore database and drag the order table to the data source sheet.
  3. Drag sales (measure) to columns and Product Name (dimension) to rows.
  4. Drag product name to filter editing option.

tableau parameter filter 1

Before applying the parameter with filter

  1. Go to Product Name filter->Select TOP->Select->By Field->enter TOP value as 20.
  2. The default top value is 10, we can change values that is the reason it is called a dynamic parameter.

tableau parameter filter 2

  1. Top 20 sale as per the product name will be displayed rather than whole data. We can observe in the previous image long list of data was available, now it is changed.

tableau parameter filter 3

After applying parameter with filter (the parameter is selected as top 20 sales for product name)

We are going to create a chart as per the top 10 sales as per the state.

  1. We have dragged the state dimension to rows and filter formatting options.
  2. Go to State ->click->select edit filter->Select TOP->Select->By Field->enter TOP value as 10.
  3. A select sum of the average value. We can select any calculation value we want from the drop-down menu of the parameter and get the requested data.

tableau parameter filter 4

  1. We will get an average sale value for the top 10 states.

tableau parameter filter 5

  • we have worked with the TOP value as a parameter. We will work with the Bottom value of the parameter. We can retrieve the result from selecting the bottom value (descending order).
  1. Go to Top filter and select field as bottom
  2. Change the value to 20.

We are going to retrieve average sales for 20 states from the bottom.

tableau parameter filter 6

  1. We have got results with average sales from the bottom for 20 states. We can see the result in the summary details of the data.
  2. Click on the blank space-> new window will open->click on the summary.

tableau parameter filter 7

We can observe in the summary count is shown as 20. The right data is displayed.

  • We can edit the summary details like what to display on the screen. We don’t need to display all the parameters. We can click on any measure like Average or Minimum which we don’t want to see, and value will disappear from the summary window.

tableau parameter filter 8

  • We can see in the below image what the result will appear. Deselected Average and Maximum.

tableau parameter filter 9

Till the time we have understood how to do it manually, but we don’t need to select and add value every time manually we can do it with creating a new parameter.

Go to Top option->select create new parameter->give parameter name->select minimum, maximum and current value.

tableau parameter filter 10

  1. We can fetch results automatically.

fetch results automatically

  1. We can select the value as 10 by moving the cursor on the parameter we have created.

cursor on the parameter

We can change the value in the parameter filters as per our choice. Click on the edit parameter.

Click on the edit parameter

  1. Users can enter a value in the parameter by typing feature. Type in value as 7.

parameter by typing feature

Parameters with sets

We can create a set for the group of values with parameter filters to highlight the data we want.

  1. We are going to create a parameter for the sales measure with a set of the subcategory dimension.
  2. Go to sub-category->click on it->select Create->Set

sub-category

  1. Go to TOP->by field select TOP N->click on ok.

We are using the parameter as TOP N because we have created TOP N parameter for the sub-category.

TOP N

  1. Set 1 is created below the measure. Drag Set 1 to color. We have got sales by the top 10.

Drag Set 1 to color

  1. We can change this value by changing the parameter value and the set will change.

Have a look at the below image. The parameter value is set to 13 and sets changes.

parameter value

Conclusion

We have learned about parameter filters and how to use it. We can use a parameter with filters and sets. We can drag parameter value automatically. We can have different editing and color choice options while using sets. We have advanced options available to make the parameter more dynamic. The parameter is the dynamic value.

Recommended Articles

This is a guide to Tableau Parameter Filter. Here we discuss How does the parameter filter done in Tableau along with the examples. You may also have a look at the following articles to learn more –

  1. Tableau Count Distinct
  2. Dashboard in Tableau
  3. Tableau Workbook
  4. Window Sum Tableau | How to Work?
  5. Guide to Tableau Order of Operations
  6. Tableau User Group | How to Create?
Popular Course in this category
Tableau Training (8 Courses, 8+ Projects)
  8 Online Courses |  8 Hands-on Projects |  55+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more