topic Comparing two dates on the Y axis in Custom Visuals Development Discussion

Comparing two dates on the Y axis

LayerWulf — Thu, 20 Jan 2022 04:51:03 GMT

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.

Re: Comparing two dates on the Y axis

lbendlin — Thu, 20 Jan 2022 21:17:13 GMT

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.

Re: Comparing two dates on the Y axis

LayerWulf — Fri, 21 Jan 2022 02:34:39 GMT

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