slicer date not working between 2 tables

[MostafaGamal]

I have 2 tables there in each one there is a column called " SubmittedOn " which contain date values and i create some measures in each table 

and i use a slicer date from one of the 2 tables but it didnt work in the other as the results still the same as there is no filter slicer is applied, please advise!

[amitchandak]

@MostafaGamal , Are using date slicer from the table or have you create a date table and joined with both tables on the required dates and using that.  In case you are using date table and less data is displayed. it means dates can have time stamp. You need to create a date column.

refer date join problem here

https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

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/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...

Calendar of your choice
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
Week of your choice
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
Appreciate your Kudos.