Count of items vs multiple dates (Line/Stacked chart)

[LazyThirdMan]

I have a dataset with multiple Items in rows and multiple dates in columns. 

E.g. 

Item #      Date1      Date2      Date3      Date4

1              1-Jan        10-Jan    15-Jan     24-Jan 

2              1-Jan        9-Jan    18-Jan     25-Jan 

3              3-Jan        14-Jan    16-Jan     29-Jan    

I would like to have a line/Stacked chart that plots the count of items (y-axis) for each column (date1, date2, date3, date4) with a separate line/stack on a single timeline (x-axis)

Is this feasible with the current charts available in PowerBI?

[amitchandak]

First of you need have all date columns idetified as date. Also create a date dimesnion and join it with all four dates. One active and 3 inactive join. Then create formula to use a date as per need.

Refer how to create formula to a particular date. Check Hire and terminate formula

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601