Forum Discussion
Solved
Comparing two dates on the Y axis
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 axi...
Thank you. I took your advice but created a new column using DateDiff to acquire the whole number.
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.
Thank you. I took your advice but created a new column using DateDiff to acquire the whole number.