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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.