Using Visual Interactions to Filter Another Visual in QuickSight

Q&A
, , ,
1

Hello,

I have a stacked bar chart in QuickSight:

  • X-axis: Date

  • Color: Availability Status

  • Value: count(vehicle_id)

I want to click a bar segment and filter a pivot table to show only the actual vehicle that make up that bar in another table.

A screenshot of a graph AI-generated content may be incorrect.
A screenshot of a graph AI-generated content may be incorrect.602×121 19.7 KB

My pivot table:

  • Rows: vehicle info (vehicle_id, name, etc.)

  • Columns: dates

  • Values: is_available flag (0/1)

  • With conditional formatting (0 = red, 1 = green)

A calendar with red and green squares AI-generated content may be incorrect.
A calendar with red and green squares AI-generated content may be incorrect.602×183 49.9 KB

My goal: clicking a bar segment should filter the pivot table to show only the vehicles contributing to that bar segment while still showing all days for those selected vehicles.

As far as I know this is not possible with filtering actions as these are based on dimensions and the bar chart only holds aggregated counts, not the actual vehicle_ids.
So when I add a filter action:

  • QuickSight only passes date and status,

  • It cannot pass the underlying vehicle_ids,

  • Therefore, the pivot table cannot be filtered down to only those specific vehicles without filtering date and /or status.

Is there any way around this limitation?

Thanks

2

Hi @JoannaB and welcome back to the Quick Suite Community!
I understand this pain point as it seems to be a limitation that many encounter. I found this older community post that covered a similar scenario. To my understanding, there is no great work around within the system, but instead would need to adjust your dataset:

Additionally though, as this is a topic that has come up more than once, I agree this would be an extremely useful feature addition so I’ll mark this as a feature request to promote visibility to the support team.