Forum Discussion

dvnnnaidu's avatar
dvnnnaidu
Helper II
6 years ago
Solved

How to Control Visual Interaction from the Visuals

Hi, I have four bar charts in a Report page, all are realted. Interaction type between them is filtering the data. Now when I click on a value on one chart, all the other charts gets filter based o...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    dvnnnaidu works for me, what power bi version you are using.

     

    in below screenshot I have selection from two visuals using ctrl+

     

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
6 years ago

dvnnnaidu you have to use ctrl when you do the 2nd selection and it will keep the first selection.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

  • dvnnnaidu's avatar
    dvnnnaidu
    Helper II
    6 years ago

    Dear parry2k , thanks for answer.

     

    I have tried CTRL+ selection of values in the second chart, but had no luck.

     

    It still deselects the value from the first chart

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      dvnnnaidu works for me, what power bi version you are using.

       

      in below screenshot I have selection from two visuals using ctrl+

       

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

      • dvnnnaidu's avatar
        dvnnnaidu
        Helper II
        6 years ago

        parry2k , thanks for the update the on the solution.

         

        I have treid this with the regular bar charts which and it's working as you have explained.

         

        In the reports where I have bar charts I have treid this and it's working perfectly.

         

        But in one of my report which I have developed I have used "Bullet Chart by OKViz". With this chart CTRL+ is not working.

         

        But in general thank you for your solution 

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      6 years ago

      Hi , dvnnnaidu 

      Through  the workaround  mentioned  by parry2k  , I can achieve a good effect, and keep their status with bookmarks.

      You can refer to my sample file.

      pbix attached

       

      Bookmark1： it shows COGS, Profit of  Paseo,VTT,velo  in USA,Canada,France

       

      Bookmark2: it shows COGS, Profit of  Velo,Amarilla in USA,Mexico

       

      Best Regards,
      Community Support Team _ Eason

       

      • dvnnnaidu's avatar
        dvnnnaidu
        Helper II
        6 years ago

        hi v-easonf-msft , thank you for your demo using bar charts.

         

        For all the reports where I have used the standard visulas it looks to be working fine.

        But same is not working properly with Custom visuals, I have used Bullet Chart by OKviz and also "Funnel with Source by MAQ Software".

        With these two charts I am not able to replicate the same functionality.

         

        Do you suggest me to raise this as a bug?

         

        Thank you,

        Narasimha Naidu