Forum Discussion
Drill Date Interactions
Drilling date hierarchies with interactions to other charts is not supported.
The only connection between the two tables with the plotted data is trough the date table.
Super UserYou 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.
- BhaveshPatel
Step 1 Create a relationshipBargraph of Table 1 Date must come from DateTableBargraph of Table 2 Date must come from Date TableCrross filter behaviour
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.
- BhaveshPatel
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.