Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Advocate III
10 years ago

Relationship Issue

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.

Need Help

3 Replies

  • Habib's avatar
    Habib
    Continued Contributor
    10 years ago

    Hi Caitlin_Knox

     

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

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    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.