Forum Discussion
dmatt
10 years agoNew Member
What/How to visualize multiple dates per product
I am looking for help for hte following scenario. I need to be able to visualize a product with 3 dates. For Example Product 1, Purchase Date, Sold Date, Return Date I was thinking that maybe...
dmatt
10 years agoNew Member
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.
v-sihou-msft
10 years agoMicrosoft Employee
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,