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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous you need to have date. dimension in your model and then link your both tables with date dimension and on x-axis use date from date dimension and value from these two tables, it will work as expected.

 

There are many blogs on how to create date/calendar dimension in your model using DAX or PowerQuery. Hope it is helpful. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks but it is not quite what I'm after using a calendar table. I want production on the same "Days of  Production" on the using Day 1 as the start date.