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.

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Here's the correct view but in excel. I would prefer to do it in PBI

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous it should work, it is plotting correctly based on your data. if you want to show day number on x -axis, just add another column in your date dimension. if there is production on day 1, it will show up. I don't have visibility to your data so cannot comment why it is not showing for day #1

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Still doesn't work on my end. Wish I can send you my PBIX file.