Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
DataAnalyst7
Frequent Visitor

Date Slicer not working at all for a fact table.

This is how The Stock Table is connected to the Date TableThis is how The Stock Table is connected to the Date TableThis is how the Date Field looks like in the Stock TableThis is how the Date Field looks like in the Stock TableTHis is the date before I apply the Date SlicerTHis 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 the data After I apply the filter. As you can see the Stock Allocated has not changedThis is how the Date Table looks likeThis 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
 
 
1 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

View solution in original post

3 REPLIES 3
DataAnalyst7
Frequent Visitor

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

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
Super User
Super User

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.