l have a page with two separate 100 % stacked column charts. They share the same date x-axis from a table containing only dates but the values come from two other tables. When i drill down on dates in one chart i would like the other chart to be drilled down as well. I have set interactions to filtering and enabled drilling on both but when i drill down on one nothing happens with the other, what am i doing wrong?
Solved! Go to Solution.
Is that all the tables are connected by relationships? What are fields that are connecting to each other.
You should always select the Date value from your date table and not from your Table 1 or Table 2.
As the relationship always flow from 1 to many direction(default), this will cross filter both the tables because they are connected with the data table relationship.
Thanks for a thorough answer but unfortunately it doesnt solve my problem! I have already done what your suggesting and highlighting works well, but i want to drill date hierarchies on both when drilling at only one of them. That is: when i press the 2015 bar in one chart it shows me all the months in 2015 and i want to second chart to do the same.
You need to create hierarchy slicer in order to view the drill down of both.
It can be downloaded from powerbi visuals website and dragging date hierarchy on to the slicer.
This would only solve your problem.
So drilling date hierarchy with interactions is not a supported feature? I guess i will have to do as you say and stick to the custom Hierarchy Slicer. Thanks again!
yes sir, you are right.
Hope this helped you to solve your problem.
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates