Date slicer not working

[Melissa]

Hi @leo_89 ,

Please read the instructions in the referenced article, you’ll find in the post.

@DavieJoe is correct, stating this is an issue with how you’ve currently incorporated this table in your model. Once you’ve followed the instructions in the article - that issue will be sorted.

Dynamic Date Range Slicer- Query M

All, Here is a solution that I use on most of my models regarding a dynamic date range slicer. I found the solution from Chris Webb, from this blog post: I changed up his solution a bit to match the solution I wanted. In order to set this up, you’ll need 2 different sets of M code. Read the blog to understand fully how this is done, but I wanted to point out that an important feature in the setup is the Relationship between the Table and the “Date Table”, Make sure in this case to have the Cr…

I hope this is helpful.