Date Slicer not working at all for a fact table.

[DataAnalyst7]

This is how The Stock Table is connected to the Date TableThis is how the Date Field looks like in the Stock TableTHis is the date before I apply the Date SlicerThis is the data After I apply the filter. As you can see the Stock Allocated has not changedThis is how the Date Table looks likeI have 5 fact tables and I created a Date Table with Date, Month , Year, quarter, week ,day of the week etc to be able to filter these tables with one date, for example October 2023. All fact Tables have date Columns which I used to connect them to the Date Column in Date Table. The other 4 Tables seem to be responding well when I filter with one date , however there is one Table that is not being filtered at all despite being connected to the Date Table. We'll call this table Stock. The Stock Table is not being filtered at all. The date column format in the Stock Table and The Date Table are the same(And I tried changing to other formats as well). I do not know what could be the reason for this considering the other 4  fact tables are responding well. Please help me and try to explain  when you do so I understand for future purpose. Thank You

[DataAnalyst7]

@selimovd I put some screenshots that can help you understand the issue

[selimovd · Accepted solution]

Hey @DataAnalyst7 ,

the relationship between the calendar table and the Stock Master table is not active.

Like that it is as if the relationship does not exist. Do a double click on this relationship and make it active. Then it should work.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[selimovd]

Hey @DataAnalyst7 ,

maybe share the file or at least a few screenshots.

We can't imagine what the problem is when you don't give more details.

Best regards

Denis