Applying filter using the Legends

Q&A
,
1

Hi I have a Line Chart where i am using Mulitple measures and i assigned colors to them. Now when i enable Legends… Through Legend colors i want to filter the visual.If i select a single color the visual should show only that Field values associated with that color.

I know direct Legends are not giving that functionality. Just checking will the funtionality is in pipeline.
I am also checking a different approach where we can use a table seperately as shown in image and try linking both. Not able figure out how we can link them both. If anyone has an idea please let me know

image
image1142×613 71.4 KB

2

Hi @P_Chandu_Reddy. Thanks so much for your post on the Community!

I asked Quick, and got this back. @Brett Could you review and validate the answer below on Monday?

" You’re right that native legend clicking to filter/isolate a single measure is not currently a built-in feature for multi-measure line charts. Legends are display-only — they don’t act as interactive filters.

Here are a few workarounds:

Option 1: Parameter + Calculated Field (Recommended)

This is the cleanest approach to simulate “legend filtering”:

  1. Create a Parameter (e.g., pMeasureSelector) as a String with values: All, Sales, Profit
  2. Add a Control (dropdown or button) tied to that parameter
  3. Create Calculated Fields that conditionally return data:
  • Sales_Display = ifelse({pMeasureSelector} = "All" OR {pMeasureSelector} = "Sales", {Sales}, NULL)
  • Profit_Display = ifelse({pMeasureSelector} = "All" OR {pMeasureSelector} = "Profit", {Profit}, NULL)
  1. Use these calculated fields as your line chart measures instead of the raw fields

This gives users a toggle that mimics clicking a legend item to show/hide a series.

Option 2: Linking Your Table to the Chart (Your Approach)

To link the table and chart as you described:

  • You’d need to use Filter Actions. However, filter actions work on dimensions, not measures. Since your table has “Profit” and “Sales” as separate rows (via calculated fields), you’d need to restructure your data so the measure name is a dimension column (e.g., a “Metric” field with values “Sales” / “Profit”) — essentially unpivoting your data.
  • If you unpivot, you can then use a single-measure line chart with Color = Metric dimension, and a filter action from the table would work. But this changes your data model.

Option 3: Sheet Navigation / Bookmarks

Create separate bookmarks or views with one measure hidden in each, then use buttons/navigation to switch between them.

Regarding the pipeline: As of now, there hasn’t been an official announcement that interactive legend filtering for multi-measure charts is on the roadmap, but it’s a frequently requested feature."

@P_Chandu_Reddy I have marked this as a feature request for our PMs.

3

Thank you so much for the response @Kristin

I think 1st approach is the closest solution but that works more as a filter instead of Legend. We’ll wait for the feature to be available in quicksight. Thank you for raising the feature request