Forum Discussion
What/How to visualize multiple dates per product
What would be the purpose of the visual (as Described)? I would imagine it'd be more useful to have the difference between the three dates, which you would then be able to add to a measure. So take the average difference (in days, hours, whatever time period makes most sense) between Purchase date and Sold date for example. Then repeat with Difference between Sold date and Returned Date.
Another technique would be to take advantage of tool tips, and add three measures which calculate the relevant dates (can be as simple as Min(Purchase Date) for example) and add them to a visual as a tool tip.
Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist.
Thanks,
Hello Ryan
I suggested the same thing but the requirement is to have a visualization instead of an excel sheet that shows the 3 dates per product. I was thinking the gnatt chart with start date and duration but thats not what the user wants.
Can you expand on the purpose or provide some insight into you're data model? What is the user looking to take away from this info, and why would it not be best to see in a table, matrix, or multi row card?
Otherwise the other idea which is similar to the first is to do a measure that takes TODAY() - MIN([Purchase Date]) for example. Then you can do a stacked bar or column chart, or even a line chart. Screenshots of data model would be helpful as well.
Hope this helps or inspires a solution for you.
Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist.
Thanks,
I don’t think there is a visual which can completely meet your requirement now. Gantt may be a suitable choice but you said it was not what the user wants.
I suggest using a ChicletSlicer to select a product and show the three dates on a Multi-row card. And using a 100% Stacked column chart to display the days between two dates (e.g. Days between purchase and sold date/Days between sold and return date). We can use calculate columns to store the number of days.
Regards,
