Filtering interactions

Question & Answer
, ,
1

Line chart

  • x-axis: ProdCat
  • value: sum(Amount)
  • Color: Country

Pie chart

  • Group/Color: ProdCat
  • value: sum(Amount)
  • Small Multiples: Supplier

  1. Line chart has filtering interactions to Pie chart i.e. clicking Country (e.g. USA) on Line chart will filter Pie chart to show only USA data. How can I show USA on Pie chart?

  2. Is it possible to click on multiple Countries on Line chart to filter Pie chart?

Thanks.

2

Hi @lbl

  1. you need to create a (filter) action on line chart with filter condition country for pie chart.
  2. no thats not possible.

BR

3

@ErikG

  1. To better clarify the requirement. The filtering is working fine for me. I am asking how to display the value of Line chart which was being clicked/filtered on the Pie chart.

Thank you.

4

Hi @lbl,
So to clarify, are you trying to signal somewhere in the pie chart as to what country the information is for?
You could do this by setting up a parameter and using that in your action. I’ve created a sample in Arena view for you to see:
Filtering interactions

For this example, you’ll create a parameter for Country, set the default to ‘ALL_VALUES’. That way your pie chart will not be filtered to begin with.
On your line graph, change your action from a ‘filter’ to a ‘navigation’ action, this way, when you select something in your line graph, it will ‘set’ your parameter value which will then change your pie graph (so setup a filter on your pie graph to limit country based on parameter).
Then you can add your parameter selection to your subtitle (or title) so that whatever get’s clicked in your line graph will then show up in the subtitle as well.

In response to Question 2; this functionality is not currently possible. The biggest reasoning is, each ‘click’ you make on a visual acts as a new selection and does not have the ability to add on to your already made selection.

Let me know if you have any additional questions; if we do not hear back in the next 3 business days, I’ll close out this topic.

5

hi @Brett

  1. Are you trying to signal somewhere in the pie chart as to what country the information is for? - Yes. Instead of ‘navigation’ action with parameter, can this be a feature request for ‘filter’ action?

  2. Click on multiple Countries to filter is possible in Power BI. Can this be a feature request in QuickSight?

Thanks.

6

Hi @lbl,
No problem, I’ll mark this as a feature request to promote visibility to the AWS support team.

Thank you