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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
ChrisR22
Helper III
Helper III

Date Slicer removing all data from visuals

I have a table of data with a date field (last modified date). This field is linked in a one-to-many relationship with my calendar table, however, when I use the date field from the calendar table in my slicer, the data from all the visuals disappears. 

Before: 

ChrisRodts_0-1704833329303.png

After: 

ChrisRodts_1-1704833343866.png

 

 

I cannot figure out why this relationship is breaking my data.

I even have another table with similar data, also connected to the calendar table via a date field, and those visuals are remaining intact. Does anyone have an idea of what might be causing this, or a proposed solution?

 

Facts:

- date fields are not generated functions, they are raw data in date/time format

- both relationships are many-to-one from data table to calendar table, single filter

- the two tables are not connected to eachother directly, but have mutual connections to other tables in my model, but not those date fields particularly

3 REPLIES 3
selimovd
Super User
Super User

Hey @ChrisR22 ,

 

can you share a sample file?

Otherwise can you at least attach a screenshot of the relationships? With only your description it's pretty hard to find the mistake.

 

Thank you and best regads

Denis

Hey @selimovd here is my model

ChrisRodts_0-1704836332956.png

 

below is the relationship in question

ChrisRodts_1-1704836479335.png

 

 

and here is the similar relationship that seems to be working fine

ChrisRodts_2-1704836527978.png

 

@ChrisR22  and what is not working? There is nothing to see from the screenshot.

Can you provide a sample file?

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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