Horizontal Toggle Buttons for Dynamic Measure Selection in Table Visual — Is it Possible in QuickSight?

Hi QuickSight Community,

We are currently migrating our reporting from Qlik Sense to AWS QuickSight and looking to replicate a specific UI feature.

In Qlik Sense, we have horizontal toggle buttons that allow users to dynamically select a Base Measure to display in a table visual — for example:

[ Sales ] [ BGP ] [ BGP Margin ]

When a user clicks a button, the table updates to show the corresponding measure values.

We explored QuickSight’s available controls and parameters but could not find a similar horizontal button-style toggle for dynamic measure switching.

Our Ask:

Is there a way to achieve this horizontal button/toggle UI in QuickSight for dynamic measure selection?
If not natively available, is there a workaround or best practice to implement this kind of measure switcher in QuickSight?

Any suggestions or examples would be greatly appreciated!

image

Thanks,

Hi @varjuna3698,

There isn’t a native horizontal button control, but you can build this measure switcher with a parameter, a calculated field, and some small “button” visuals.

The first step is to create a string parameter (for example, pMeasure) with a default value such as Sales. You don’t need to add a control for it. then if you create a calculated field that switches the measure based on the parameter, and use it as the value in your table. The documentation shows this pattern with ifelse:

ifelse(

${KPIMetric} = 'Sales',sum({Weighted Revenue}),

${KPIMetric} = 'Forecast',sum({Forecasted Monthly Revenue}),

${KPIMetric} = '# Active', distinct_count(ActiveItem),

NULL

)

For each option, create a calculated field that holds just the label (for example, ‘Sales’), put it in its own small table visual, and hide the title and headers so only the cell shows. Then add a navigation action to each one that targets the same sheet and sets pMeasure to that button’s value. Place the three visuals side by side for the horizontal row.

Optionally, you could add the parameter to the table’s title so readers can see which measure is selected, since the column header will show the calculated field’s name rather than the chosen measure.

The button approach is covered step by step in this earlier thread, including a working example: Buttons in Quick. And here’s the official AWS documentation I was looking at (which has the calc field example above):

Hope this helps and feel free to reply with clarifications or follow up questions!

Thank you for your response @WLS-Cesar , i will try to implement this , keep you posted the updates.

-Thank you.

Hi @WLS-Cesar ,

I am trying to implement the 2 buttons using Table visual, and trying to implement show and hide the visuals based on this Buttons in Quick - #7 by Kripa (Brett Solution)

iam not able to achieve the same .

can you help me what is the issue in my below arena app (Please refer sheet 5)

navigation ←Arena : Click the link to view dashboard / copy underlying analysis.