Filter through tables has no effect on visual

[Anonymous]

Hi,

Need help fast!!! (thanks in advance!) I created a relationship between 3 tables. See printscreen. On table 'XXBI_PLAN_SUPPLIES' I created a visual that summarizes all planned order lines in the table. I have to exclude certain items for which the key field to exclude is in the table 'XXBI_ITEMS'. Therefore I created a filter in the query mode on table XXBI_ITEMS on that specific field (Which only equals items with release time fence = NULL). When I apply this settings, this does not change my my visual so the numbers which appear in the table are not changed that items with release time = NULL are excluded. By the way I am using direct query mode on the database. Is there someone who has a solution for this???

[v-yulgu-msft]

Hi @Anonymous,

"Therefore I created a filter in the query mode on table XXBI_ITEMS on that specific field (Which only equals items with release time fence = NULL)." What did the "Query mode" mean in your post? How did you apply filter? If you add release time to a slicer and select NULL from slicer, did it work? Also, please try to apply filters in "Visual Level filter".

Regards,

Yuliana Gu

[Ruksuro]

Have you tried editing the relationship to "Both"?