Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Drilling date hierarchies with interactions to other charts is not supported.
Drilling date hierarchies with interactions to other charts is not supported.
Is that all the tables are connected by relationships? What are fields that are connecting to each other.
The only connection between the two tables with the plotted data is trough the date table.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |