Forum Discussion

XLBob's avatar
XLBob
Resolver II
8 years ago
Solved

bug in Power BI Desktop (Filtering not working as expected)

simple sample data here, 1 fact and 1 lookup. standard relationship between lookup and fact. as you can see in very top JPG, when I select 0 from lookup, only 1 row which has traffi...
Need Help
  • RahulYadav's avatar
    RahulYadav
    8 years ago

    Hi XLBob,

    There seems to be an issue if there are nulls in Numeric field used for joining two tables. If you convert the Traffic & Gov Traffic PA fields to "Text" then the issue is not replicating.

     

    Thanks,

    Rahul

     

     

     

     

  • XLBob's avatar
    XLBob
    Resolver II
    8 years ago

    Seems like it's seeing 0 the same as NULL (blanks)

    • MattAllington's avatar
      MattAllington
      Community Champion
      8 years ago

      You cannot have a blank as a foreign key in a data table.

       

      edit:  well clearly you can, but you shouldn't

      • XLBob's avatar
        XLBob
        Resolver II
        8 years ago

        MattAllington Thanks for your reply. I am not convinced by the fact that having blank as a foreign key in a data table is the reason why it's doing that. When I filter blank it's only giving me the balnk row in fact table.