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.

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.

speedramps's avatar
speedramps
Super User
4 years ago

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.