Forum Discussion
Visual Interactions not working
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
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 ?
I don't think the visual interactions have anything to do with it working (or not). My report has a financial year slicer on the whole report, the chart we use to drill down filters two other charts but not the 4 KPIs on the same report, lots of custom interactions.
Reading the other comments whether is it working on not seems completely random, which is rather strange.
The only other thing I did recently was I got a notice to update to a new PBI Desktop. So I updated the software, reloaded/refreshed the data model, and republished to the service.
This was using IE 10. I just tried Chrome as well and it works there too.
I put the new version on this week of Power BI and my new projects will not link via the Edit Interactions correctly. If I open a project created before I put on the upgrade the interactions are fine. What's up with that?
Just stumbled upon something that might apply here. While experimenting with drilldown interactions, I noticed that as I drill down through a hierarchy, a cross filtered visualization was not filtering. Once I got to the level I was interested in, I noticed that if I turned off drill down (top right down arrow), the other visual(s) filtered like they should. Also, with no drill down turned on at the level, clicking on any bar or column at that level of the hierarchy allowed cross filtering to occur. Turn drill down back on, cross filtering ceases, and you can continue your drill down and then repeat the process at the next level.
Correct: Turning on drill mode disables the ability to 'select' a bar, and hence filter on it.
