How we can filter one visual based on selection in another visual dynamically

[rkalyan1486]

Hi ,

I have transactional data which is like as below

I have created two visuals one is a donutchart and another one is a bar graph, the bar graph shows the counts of each transaction and pie chart will show the total transactions year wise like as below

when i select any bar in the graph it should change the donut chart accordingly,

for example if i select count of transaction 1 in the bar graph then the donut has to show, 2019-4 transactions, 2020- 4 transactions, 2021- 5 transactions.

Thanks

[rkalyan1486]

I have not only year column, but also contains other columns like invoice number, account number and so on how i can handle all these columns.

please suggest.

Thanks

[onurbmiguel_]

Hi 

can your share a exmaple of your table  (with dummy values)

BR 

Bruno 

[rkalyan1486]

Please find the link of sample data

Thanks

[onurbmiguel_ · Accepted solution]

Hello, 

Please look at this example in this LINK

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

[onurbmiguel_]

Hello 

May i suggest that change your inicial table to something like that :

Year	Transaction
2019	Tran_1
2019	Tran_1
2019	Tran_1
2019	Tran_1
2020	Tran_1
2020	Tran_1
2019	Tran_2
2019	Tran_2
2019	Tran_2
2020	Tran_2
2020	Tran_2
2019	Tran_3
2019	Tran_3
2019	Tran_3
2020	Tran_3
2020	Tran_3

like this when i select a specific transaction it will filter the other visuals

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC