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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.