Relationship Issue

[Caitlin_Knox]

Something is wrong here, and I can't quite figure out what the issue is. I have 4 different tables [2 SharePoint Online Lists, 2 SQL Tables] that I'm trying to get all connected nicely through relationships. They all have common fields so I feel like it shouldn't be this difficult. Here's a screenshot of what relationships I have active now

One specific problem I have is shown in the following screenshot. I KNOW that there is only data for Nov15 in the Fixed Cost list, however- the only way this card shows data is if I choose the 'Blank' slicer from the Date Table.

[Eric_Zhang]

@Caitlin_Knox

What is the year filed in the slicer? How do you get a (BLANK) in the year? I doubt it is the problem in data.

Can you upload the pbix, do mask and clean up sensitive data before uploading.

[Habib]

Hi @Caitlin_Knox

Can you please verify the Cardinality and Cross Filtering relationship between your first two relationships?

[Caitlin_Knox]