I have created a calculated field that will select a calculation based on a parameter that the user selects. For example, if the user selects “Calculation A” in the control, then this will return the value associated with “Calculation A”.
When this calculation is in a visual, the tooltip won’t dynamically change to show “Calculation A”, instead it will show the calculation name itself and won’t dynamically change based on the selection. As a workaround I have created another calculation that returns just the parameter and have placed this above the value in the tooltip so it will show something like this:
Calculation A
200
(instead of Calculation A 200)
However, the visual now needs to include additional measures that are independent of the parameter and when adding this, it is presenting the tooltip in the standard way (horizontal), while my parameter-driven measure is displayed vertically. This creates a disjointed view in the tooltip with one showing the values horizontally and one vertically.
A workaround I tried was with the sheet tooltip but couldn’t find the right solution for this.
I hope this makes sense but if not, happy to provide more info
Hi @williamsonc and welcome to the Quick Community!
The core issue is that standard detailed tooltips don’t support dynamic labels. The label for a field in the tooltip is always the static text you enter when editing it, so there’s no way to make it change based on a parameter selection. That’s why your workaround of adding a separate calculated field to show the parameter value creates the formatting mismatch you’re seeing: dimensions displayed as “Unique Value” render differently from regular measures in the detailed tooltip, and there’s no way to control that layout.
Sheet tooltips give you full control over how everything is arranged. You’d create a tooltip sheet (Format Visual > Interactions > Tooltip > Sheet tooltip), then use a text box on that sheet with a parameter reference (<<$YourParameterName>>) to display the dynamic label. Since text boxes in QuickSight support parameter references, the label will update whenever the user changes the control selection. For the values themselves, you can add a KPI visual or a small table showing both your parameter-driven measure and your other independent measures, all in the same consistent layout since sheet tooltips use free-form positioning. You can read more about the setup in this AWS blog post on sheet tooltips and the tooltip documentation.
One thing to keep in mind is that sheet tooltips recalculate measures in their own isolated context, so if any of your independent measures use table calculations (like runningSum or percentile rankings across rows), those won’t carry over. Regular aggregations work fine though. Also, your sheet tooltip can be up to 640px wide by 720px tall and include up to 5 visuals, so you have plenty of room to lay things out cleanly.
Hope this helps and let me know if you have any additional questions!
My independent measures are causing me a bigger issue now. I have a multi-value parameter which allows users to select different measures they are interested in, and I have created calculated fields that dynamically return the relevant measure(s) based on the user’s selection. This allows me to add/remove different lines on a graph depending on what the user selects.
This works as expected in the visual itself, but I am running into an issue when using these fields in a sheet tooltip. Even when the calculated field returns null, the row/field still appears rather than being hidden.
From what I can see, QuickSight does not appear to have a way to “hide” rows where a calculated measure returns null. Is there a recommended workaround for this scenario?