Forum Discussion
Drill down into multiple graphs simultaneously?
I an a relative novice when it comes to Power BI, so please avoid instructions involving coding or otherwise advanced steps.
On a report page I have 2 line chart visuals showing different data over a range of dates. Users can click the drill down buttons on the charts to view by year, quarter, or month granularity. But doing so on the first chart does not also do so on the 2nd chart, requirign the user to manually drill down into each chart seperately. Is there a way to link the drill down functions of the first chart and the 2nd chart together so that a user only needs to press the drill down buttons once to see the effect on both charts?
Create a calendar table.
Then create 1:M relationship from calandar[date] to table1[date].
Then create 1:M relationship from calandar[date] to table2[date]
Draw your graph with calendar[date] on the x-axis and tabel1 and table2 measures
Please click the thumbs up and accept as solution buttons.
6 Replies
Hi JLaine
No, you cant drilldown on one line graph and automatically drill down on another line graph.
Consider drawing both lines on the same graph.
Perhaps you are so new that you didnt know that you have hace multiple lines.
Sorry if this is not the answer you wanted, but it is an answer.
Please click the thumbs up and accept as solution buttons.
speedramps I know I can have multiple measures on a single graph, but the two graphs have different X-axis date fields (first is date the first table's items were created, 2nd is the date the 2nd table's items were created), and I don't know how to merge the 2 different X-axis fields together on a single graph.
Create a calendar table.
Then create 1:M relationship from calandar[date] to table1[date].
Then create 1:M relationship from calandar[date] to table2[date]
Draw your graph with calendar[date] on the x-axis and tabel1 and table2 measures
Please click the thumbs up and accept as solution buttons.
speedramps thank you, but I already have relationships between my 2 data tables, so when I tried to ad a calendar table will relationships to all of my date fields (there are multiple date fields in each data table), things didn't work.
Hi again JLaine
If you have multiple date fields in tables then you can can create "role playing" relationships.
Here is an example.
Click here to download an example
As previouslydiscussed , you cant drilldown on one line graph and automatically drill down on another line graph. The solution is to draw both lines on the same graph.
Consider changing you datamodel to use a calendar table. That is the best pratice for a good reasons.
The have USRELATIONSHIP dax measures that can handle multiple date fields on the fact tables, but all tied to central calendar date on the x-axis.
