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

     

     

     

     

RahulYadav's avatar
RahulYadav
Resolver II
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

    RahulYadav,Thanks for your brilliant idea. I will give this a try next Monday. I need the Traffic value to be INT type as it's used in numeric calculation. Anyway, x1 will convert any number as text back to numbers so it doesn't concern me too much. But I still hope that MS can fix this.