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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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