Forum Discussion

rkalyan1486's avatar
rkalyan1486
New Member
4 years ago
Solved

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_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant

    Hello 

     

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

     

    YearTransaction
    2019Tran_1
    2019Tran_1
    2019Tran_1
    2019Tran_1
    2020Tran_1
    2020Tran_1
    2019Tran_2
    2019Tran_2
    2019Tran_2
    2020Tran_2
    2020Tran_2
    2019Tran_3
    2019Tran_3
    2019Tran_3
    2020Tran_3
    2020Tran_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

  • 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_'s avatar
      onurbmiguel_
      Icon for Power Participant rankPower Participant

      Hi 

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

      BR 

      Bruno