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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi , if suppose i have 3 to 4 variable in x axis(other than calander), and same variables in another bar chart, and i want to drill down both charts simultaneously, any way?