Forum Discussion

JLaine's avatar
JLaine
Helper I
4 years ago
Solved

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 ...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    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

    Watch these video 

     

    Please click the thumbs up and accept as solution buttons.

speedramps's avatar
speedramps
Super User
4 years ago

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.

 

 

 

JLaine's avatar
JLaine
Helper I
4 years ago

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.