Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dmatt
New 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 it could be done in a stacked bar chart or something but cannot figure it out. The dates seem to always show up as count when I put in as data. Ideally the products would be listed on the Y axis with dates going along the X axis.

 

Anybody have any idea how to do this or perhaps an online tutorial where this is already done?

 

Thanks In Advance

5 REPLIES 5
Anonymous
Not applicable

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,

Ryan Durkin

 

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.

@dmatt

 

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.

369.jpg

696.jpg

Regards,

Anonymous
Not applicable

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,

Ryan Durkin

 
sdjensen
Solution Sage
Solution Sage

I only think you can do this if you use the table or matrix visual. I can't think of any of the other visuals that will be able to handle this.

/sdjensen

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.