Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Shared Axis on different data tables - line graph

I have 2 data tables which showed 2 oil wells with different production start date. I want to show on a line graph the 2 wells with the same day of production on the x-axis. However, my graph shows o...
General Comment
jtownsend21's avatar
jtownsend21
Icon for Responsive Resident rankResponsive Resident
7 years ago

My first suggestion is to append the two tables together in the query editor. I have a similar data set that I do this with. 

 

Alternatively if you don't wish to create a new table you can create a relationship between the two tables on "Days of Production" but leave it inactive. From there create a new measure: 

Measure = 
     CALCULATE(
          SUM(
               'Table 1'[Oil (Barrels Produced)],
               'Table 2'[Oil (Barrels Produced)]
          ),
          USERELATIONSHIP(
               'Table 1'[Days of Production],
               'Table 2'[Days of Production]
          )
     )