Forum Discussion

Ngauti's avatar
Ngauti
Frequent Visitor
1 year ago
Solved

table visual should react based on measure on bar charts

sr noamountmonths
32306-03-2025
33106-03-2025
34206-03-2025
35506-03-2025
36606-02-2025
37706-02-2025
38806-02-2025
39906-02-2025
402206-01-2025
41106-01-2025
42406-01-2025
43306-01-2025

Hi Team,

I have a table above

i have created 2 measure

Greaterthan4 = CALCULATE(COUNT('Table'[sr no]),'Table'[amount]>=4)
Greaterthan2 = CALCULATE(COUNT('Table'[sr no]),'Table'[amount]>=2)
and created a 2 bar chart visual below & 1 table visual,
if i select on any bar then my table visual should react based on that
for example 
if i select for mar 2025(bar chart1) & it has only 1 count then my table should also react only 1 row
same if i select for feb 2025(bar chart2) & it has only 4 count then my table should also react only 4 rows

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Ngauti ,

     

    Go to the Format pane for the visuals.

     

    Check that Edit Interactions is enabled.

     

    Click on the visual, and confirm that the interaction between it and the table visual is set to "filter."

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Ngauti ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Ngauti ,

     

    Go to the Format pane for the visuals.

     

    Check that Edit Interactions is enabled.

     

    Click on the visual, and confirm that the interaction between it and the table visual is set to "filter."

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • v-sdhruv's avatar
    v-sdhruv
    Community Support
    1 year ago

    Hi Ngauti ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You

  • v-sdhruv's avatar
    v-sdhruv
    Community Support
    1 year ago

    Hi @Ngauti ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You

  • v-sdhruv's avatar
    v-sdhruv
    Community Support
    1 year ago

    Hi @Ngauti ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank You