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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.