Forum Discussion
Helper IWhat visaulization can be shown for date difference?
Hi
I have two date columns such as product agreed delivery date and product actual delivery date. I have calculated the differences between these dates in the power query and created a new column called differences
I wanted to visualize the dates with differences. What is a suitable visualization that can be create?
Please advise.
Jason2500 You can create a visual like below to show items where delivery was delayed. I have created one measure that can be used in a tooltip to show for how many days delivery was delayed
First Measure
Diff = INT(SUM('Delivery Date'[Agreed Delivery Date]) - SUM('Delivery Date'[Actual Delivery Date]) )Second Measure
Delivery_Msg = if ([Diff]>=0, "On time delivery", "Delivery was late by " & -1 * [Diff]) & " days"I would recomned to use either bar chart or line chart to show variance for products where delivery was delayed. let me know if it works for you. cheers
2 Replies
- negi007
Community Champion
Jason2500 You can create a visual like below to show items where delivery was delayed. I have created one measure that can be used in a tooltip to show for how many days delivery was delayed
First Measure
Diff = INT(SUM('Delivery Date'[Agreed Delivery Date]) - SUM('Delivery Date'[Actual Delivery Date]) )Second Measure
Delivery_Msg = if ([Diff]>=0, "On time delivery", "Delivery was late by " & -1 * [Diff]) & " days"I would recomned to use either bar chart or line chart to show variance for products where delivery was delayed. let me know if it works for you. cheers
