Date slicer filteration is not working as expected

[Mazex1985]

Hello,

      I have a table called bookings, there is a field called booking date. I added a date table that equals calendarauto().

I added a relationship between the date in the created table and the from in the bookings table, when i add the slicer to the form, somehow the filter is not being applied correctly, it always works only if i drag it to the ends(which means no filter).

Any idea why?

Thanks.

[v-robertq-msft · Accepted solution]

Hi, @Mazex1985 

According to your description, I think you should first check the relationship between the Calendar table and your main table, the Filter direction should be from the Calendar table to the main table, like this:

Then you can check if you have place the correct field in the Slicer, and if the data in the columns can be affected by the Slicer.

What’s more, you can also go to the “Format”->”Edit interaction” to check if the interaction is enabled in your Slicer, like this:

For more detai about ”Edit interaction”, please refer to this document:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions#change-...

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnkitKukreja]

Hi @Mazex1985 

Make sure, your date table is marked as Date table and you have active relationship among, booking date and your date table, else write proper dax for inactive relationship.

Also, use date filter from Dates table and please make sure the available dates is selected.

Please share you're pbix file or sample data for solution.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

[amitchandak]

@Mazex1985 , Do you two dates? and want to filter book date and join on a created date.

If that is the case please refer to how to work with two dates.

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

If join is correct and still it is failing check what time intelligence fails -https://www.youtube.com/watch?v=OBf0rjpp5Hw

I doubt created date has a timestamp.