cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LayerWulf
New Member

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 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. 

 

PBI Chart.png

1 ACCEPTED SOLUTION

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

PBI Chart 2.png

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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. 

PBI Chart 2.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors