You want viewers to choose whether the same bar chart displays Sales, Profit, or Quantity without changing the underlying data or adding duplicate worksheets. Which approach is most appropriate for giving them this interactive control?
Add a quick filter so users can include or exclude Sales, Profit, or Quantity fields.
Build a parameter listing the three measures and reference it in a calculated field that drives the bar's value.
Create a dimension hierarchy so users can drill down from Sales to Profit to Quantity.
Enable manual sorting so users reorder the bars based on Sales, Profit, or Quantity.
A parameter is not tied to a specific field in the data source, so it lets users select values that may represent different measures, custom thresholds, or other constants. By creating a string parameter listing "Sales, Profit, Quantity" and using it in a calculated field (e.g., CASE [Measure Selector] WHEN "Sales" THEN SUM([Sales]) …), the single view can update dynamically. Filters, hierarchies, and sorts rely on existing fields in the data and therefore cannot swap one measure for another within the same axis.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
How does a parameter differ from a filter in Tableau?
Open an interactive chat with Bash
What is the purpose of a calculated field in Tableau?
Open an interactive chat with Bash
Can you explain the role of a CASE statement in constructing dynamic visualizations?
Open an interactive chat with Bash
Tableau Desktop Foundations
Exploring and Analyzing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .