Forum Discussion
How we can filter one visual based on selection in another visual dynamically
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
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
5 Replies
- onurbmiguel_
Power Participant
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 - rkalyan1486New Member
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_
Power Participant
Hi
can your share a exmaple of your table (with dummy values)
BR
Bruno
- rkalyan1486New Member