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

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.

JLaine's avatar
JLaine
Helper I
4 years ago

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.