Forum Discussion
Date Slicer
Hi I am not able to get the date slicer to work. I have one table called Quotes & another called Sales. I have created another table called Dates - which has unique dates. I have created many to one relationships between Sales & Dates and Quotes & Dates, and created a Date Slicer based on the Dates table, however when changing the dates in the slicer the tables in the report view are not changing. Can someone help please?
10 Replies
Just check your joins are in active mode. Means join line is a strong line, not a dotted line.
Do your date/s, in fact, have timestamp?
Can you share some screenshot dates(joining columns) by hiding sensitive information?
Hi Anonymous
Check the "direction" and "status" of the relationships.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
If the issue is not sloved by yourself, please share some screenshots so that i can figure out for you.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
