Forum Discussion

derekma19's avatar
derekma19
Frequent Visitor
3 years ago
Solved

Line Chart with two lines with different values and dates using a unique X axis

Hi, I'm trying to display 2 lines of values based on different dates. The data is as shown as below.

 

StartDateEndDateStartValueEndValue
01 Jan 202115 Jan 202156
01 May 202125 Jun 20211521
01 Aug 202101 Sep20212426

 

now I want to put in the same line chart both lines. However, if I use StartDate in the X Axis, the EndValue won't be correctly displayed and the same will happend with the Start Value.  For example, in the image below the 01/Sep/2021 it is displaying 24 and 26 when it should be only 26. Image below for reference.

 

I'm getting this

 

and I want to get something like this 

 

 

I believe I need a DateTable from the dates I am interested in and make a relationship with my dates table but I've tried relationship with Start and End Date and It doesn't work.

 

Any idea is more than welcome

 

Thanks!

 

 

 

2 Replies