QuickSight Parameters: Creating Control Filters Across Multiple Sheets

Learn how to use QuickSight parameters to create dynamic control filters that apply across multiple visuals and sheets.

Home
Resources

Hello, my name is Duncan, and I'm a data engineer with West Loop Strategy, an AWS partner. Today, we’ll explore how to use QuickSight parameters to build powerful filters.

Why Use QuickSight Parameters?

QuickSight parameters let users dynamically filter data across multiple visuals and sheets. Instead of applying filters separately, a parameter allows a single selection to affect multiple elements.

This improves user experience by making filtering more efficient and intuitive.

Creating a Parameter in QuickSight

To create a parameter, go to the top left of the QuickSight interface and click “Add” > “Add Parameter”.

Choose a field with a string data type. For this example, we’ll use Product.

For consistency, use a structured naming convention. Options include all caps, underscores, or numbering.

Setting Up a Control for the Parameter

Once the parameter is created, you can define its functionality:

  • Select “Multiple Values” if users need to compare multiple products.
  • Leave the default value blank to show all options before filtering.
  • If no default value is set, the filter can be either blank or default to “Select All.”

Click “Create” to finalize the parameter setup.

Applying the Parameter to a Filter

To make the parameter functional, add it to a control. In QuickSight:

  • Choose “Control” from the options.
  • Name the control meaningfully, e.g., “Product Selection.”
  • Select a filter type—Drop Down or List for better user experience.
  • Link the control to the dataset so it reflects real-time values.

Filtering Across Multiple Sheets

Once the control is set, apply it to a filter:

  • Select a visual and open the filter panel (funnel icon).
  • Click “Add Filter” and choose Product as the field.
  • Set the filter type to “Custom Filter.”
  • Choose the condition “Equal” and enable “Use a Parameter.”

By repeating this setup on multiple sheets, the same parameter will apply across all of them.

Conclusion

QuickSight parameters simplify filtering by allowing a single control to filter multiple visuals and sheets.

For more insights or QuickSight training, visit our website or follow us on LinkedIn.

Continue Series

You may also like

View all
Mastering QuickSight Permissions: The Key to Secure Access Control
Mastering QuickSight Permissions: The Key to Secure Access Control

Optimize your cloud journey with advanced AWS analytics solutions. Learn how West Loop Strategy can transform your business with data.

QuickSight Visuals - Custom Insight Narratives
QuickSight Visuals - Custom Insight Narratives

In today’s video, Dylan, our talented cloud developer at West Loop Strategy, takes you through the exciting world of AWS QuickSight. As part of our AWS Analytics Expert Series, Dylan will guide you on how to build and customize narratives to create powerful insights.

QuickSight Custom Visual Content: Simple Ways to Personalize Dashboards
QuickSight Custom Visual Content: Simple Ways to Personalize Dashboards

Learn how to add QuickSight custom visual content, including embedded images and website elements, to personalize dashboards.

F.A.Q.

Find answers to common questions about cloud migrations, Amazon Web Services (AWS) and working with West Loop Strategy.

Why choose West Loop Strategy?

West Loop Strategy’s mission is to combine AWS technology with deep expertise to deliver best-in-class solutions to business problems, not technology for its own sake.  That means efficient, cost-effective solutions that add value to your business.

Why should you migrate to the cloud?

Cloud migration is the process of moving your organization's data, applications, and infrastructure from on-premises servers to the cloud. If that sounds complicated or like a lot of work, consider the benefits. Moving to the cloud allows businesses to shift from large upfront capital expenditures (CapEx) on hardware and infrastructure to operational expenses (OpEx) that can be deducted from taxable income. This pay-as-you-go model improves cash flow, reduces financial risk, and provides greater flexibility to scale IT resources as needed. If you set it up right - you can stop running inflexible workloads that are "always on" and instead take advantage of native solutions that scale up and down based on your actual usage.

Our team of AWS certified Solutions Architects at West Loop Strategy is here to guide you through this transition, ensuring it's tailored to your business and its unique requirements. From initial assessment to seamless execution, we'll help you navigate the complexities of cloud migration with confidence.

What are the benefits of migrating to AWS?

AWS is the clear leader among the public cloud providers. They have the most advanced features & products, the highest uptime, the lowest prices, and the best customer support.  Whether you are moving a solution from on-prem to the cloud, modernizing an old stack of legacy products, changing business intelligence platforms, or leaving Azure/GCP, AWS has a solution for you.

Why hire an Advanced Tier AWS Partner?

Achieving Advanced Tier Status within the AWS Partner Network (APN) is no easy feat.  It takes a years-long track record of successful customer projects to even qualify to apply.  West Loop Strategy achieved Advanced Tier status in 2022 and has earned more AWS Service Delivery designations than any other Advanced Tier partner along the way.  For customers, this means that if you work with West Loop Strategy, you’re working with a dedicated partner trusted by AWS themselves to deliver work that demonstrates the AWS pillars of success – operational excellence, security, reliability, performance and cost efficiency.

What services does West Loop Strategy provide?

West Loop Strategy is an Advanced Tier AWS Consulting Partner specializing in end-to-end cloud solutions. Our expertise spans application development and modernization, cloud migration, AI/ML and analytics, cloud security, and DevOps. Committed to delivering scalable, secure, and high-quality solutions, West Loop Strategy helps organizations make the most of the cloud on AWS.