Forum Discussion

cproloff's avatar
cproloff
Advocate I
9 years ago
Solved

Visual Interactions not working

It appears that visual interactions on not working. For some reason when I drill down to lowest level on a visual and then select one item, none of the other charts update on the report. It was worki...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    cproloffhl1357ReubenLamAnonymousbc_teixeira In my environment, cross filtering is working on all drill down levels. Please check the drill down report in your scenario to see if the issue is gone.

     

    Best Regards,

    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

cproloffhl1357ReubenLamAnonymousbc_teixeira In my environment, cross filtering is working on all drill down levels. Please check the drill down report in your scenario to see if the issue is gone.

 

Best Regards,

Qiuyun Yu

  • bc_teixeira's avatar
    bc_teixeira
    New Member
    9 years ago

    Hi Qiuyun_Yu, 

     

    True! It's working here too.

     

    Thanks a lot

    • ssah's avatar
      ssah
      New Member
      8 years ago

      Looks like the 'Edit Intractions'  shows up exactly on one visualization on the page. 

      After clicking 'Edit Interactions' just check the visualisation on the page where it shows up, click it there and the 'interaction' menu will hop to the net visualization. 

  • cproloff's avatar
    cproloff
    Advocate I
    9 years ago

    Hi Qiuyun Yu,

     

    I checked in my environment and it is now working on all drill down levels!!

     

    Thanks

     

    Collin

  • DavidMoss's avatar
    DavidMoss
    Advocate V
    9 years ago

    I also have the same issue. I have a 2 level hierarchy (Continent - Country) in the axis of a clustered column chart. When we click a column within this chart at the top level of the hierarchy  YES it cross filters all the other reports on the same report page. YEt when we drill down to level 2 and click a column within the chart it does not cross filter. This is the same for both in Power BI desktop and also when published to the Power BI service.

    (PS yes the tile interaction settings with other tiles is definately set to filter as it works at top level)

     

    This is strange how for some people it is working and others not. How is this ?

    I have Power BI desktop V2.38.4491.282 64 bit (August 2016) on Windows 10

    and using MS Edge when in the service .

     

    For you guys that it is working does it work both when you drill down (single arrow option) and also when you move down a hierarchy level (2 arrow option).

     

    this is driving my client crazy as 1st they want to see the data at continent level and then they need to drill down from global continent level to country level and want thnen to obviously see all the data at country level.

    HELPPPPPPPPPPP

    • hl1357's avatar
      hl1357
      Frequent Visitor
      9 years ago

      Ours is working for both the behaviours you listed.

      We are using a basic column chart to filter another column and a tree map.

       

      If it helps...

      The column chart does not use a formal heirachy, we have just listed the fields we want in axis column and they are from mulitple tables in the data model.

      • DavidMoss's avatar
        DavidMoss
        Advocate V
        9 years ago

        hl1357 When i saw your comment i had hoped it was that simple a solution to replace the formal hierarchy with the 2 seperate attributes.

        But it still doesn't work.

        Very strange.

         

        Could have anything to do with the fact that i have also 'personalised' the interaction (of the chart in question) with the other charts on that page. YOu know when you select menu option > Format > Edit Interactions and some are set to filter and some highlight and even 1 to no interaction. ?

         

        Most frustrating to know it works for you guys and us not.

        My data model is solid...

         

        Will dig deeper and get back later........

         

        And now i have just seen ReubenLam comment so that also excludes that possible error.

         

        ANyone got any other ideas what it could be ?

         

    • ReubenLam's avatar
      ReubenLam
      Frequent Visitor
      9 years ago

      Yes, Works for both the single arow down icon and right click drill down functionality.

       

      I also changed my interaction from Filter to "highlight" and the feature worked as it supposed to.

       

      I used both a Hierarchicy (geography) and a slicer on my report.

       

      -- Reuben.