cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors