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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ChrisR22
Helper II
Helper II

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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