Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Filter through tables has no effect on visual

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

Need Help

2 Replies

  • Ruksuro's avatar
    Ruksuro
    Icon for Helper III rankHelper III
    8 years ago

    Have you tried editing the relationship to "Both"?

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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