Comparing two dates on the Y axis

[LayerWulf]

Hello Community,

I'm trying to duplicate a chart I created in Excel into PBI. I need to compare the difference in shipping dates vs. installation dates for certain equipment. Therefore, the X axis will be the equipment ID's and the Y will compare the two dates for each tool. In Excel I have 3 columns: Tool ID, Ship Date, Install Date and it's graphed out as such. The data labels are just the difference in days between the two days. I have not been able to replicate this in PBI. Any assistance/guidance would be greatly appreciated. 

[lbendlin]

You are using a visual type that is unsuitable for the story you are telling. A line chart implies a dependency between the items on the x axis, like a temporal succession. Your products are independent of each other and should not be connected via a line.  Use a column chart instead.

You can convert dates to Whole Number format and use that for the column values.

[LayerWulf · Accepted solution]

Thank you. I took your advice but created a new column using DateDiff to acquire the whole number.