Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.