I am having a persistent issue with a Parameter Action and would appreciate any help. I have a dashboard with a bubble chart and a treemap. My goal is to click a bubble (representing a measure like 'Discount' or 'Quantity') and have the treemap dynamically update its size based on that selected measure.
1. My Goal:
To click a bubble in the bubble chart and swap the measure used for sizing on the treemap.
2. My Setup:
Bubble Chart: Measure Names is on both Color and Detail. Measure Values is on Size and Label. This creates separate bubbles for SUM(Discount) and SUM(Quantity).
Treemap: Sub-Category is on Detail. SUM([Treemap Value]) is on Size and Label.
Parameter: [Select Measure] is a String parameter with a list of values: "Discount" and "Quantity".
Calculated Field: [Treemap Value] uses a CASE statement to dynamically select the measure based on the parameter:
CASE [Select Measure]
WHEN "Discount" THEN [Discount]
WHEN "Quantity" THEN [Quantity]
END
Parameter Action: The action is configured to run on Select from the bubble chart sheet. The Target Parameter is [Select Measure], and the Source Field is Measure Names.
3. Crucial Diagnostic Result:
When I click on a bubble, the [Select Measure] parameter control on the dashboard DOES NOT change its value. This indicates the action is not firing.
4. Attachments:
Please see the attached screenshots of my worksheet setups, parameter configuration, and dashboard action dialog. A packaged workbook (.twbx) is also available upon request.
5. My Tableau Version: 2022.3
I am completely stumped. Any insight into why the action might not be firing despite this setup would be incredibly helpful. Thank you!
@Joe Cooper Your source is the worksheet 'bubble chart', but that is not what you are selecting for the parameter action. You need to change the source to the Dashboard and check the 'bubble chart' there'
James Emery
Tableau Forums Ambassador
Please click 'Select as Best' on the one reply that answers your question.