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

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.