Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to Solution.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.