Forum Discussion

gilsonoliveiraj's avatar
gilsonoliveiraj
New Member
8 years ago
Solved

Report Level Filter not considering relationships

Hi Community,   Need your help! I'm creating a dashboard and the filter at Page level isn't working as expected for a single visual. In this scenario I have 4 main tables: Release Table: Infor...
Need Help
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi gilsonoliveiraj,

     

    For all the three relationships, please set the "Cross filter direction" to "Both".

     

    Best regards,

    Yuliana Gu

auridasf's avatar
auridasf
New Member
7 years ago

I have the same problem.

I have a FACT table with DateKey, and a DATE table with DateID, where DateKey = DateID. 

DATE table has DateID values from 20090101 to 20191231

FACT table has DateKey values from 20171201 to 20180901.

 

I apply the Cross filter in relationships with "Both" setting, but when I add the DATE.DateID to "Report Level Filtering", it shows values from 20090101 to 20191231, not from 20171201 to 20180901. Does the relationship cross filtering not work?