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
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
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.