Forum Discussion
Helper Vslicer date not working between 2 tables
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!
1 Reply
- amitchandak
Super User
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
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-YTD-LYTD-Week-Over-Week/m-p/1051626#M184Calendar of your choice
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
Week of your choice
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
Appreciate your Kudos.
