Forum Discussion

XLBob's avatar
XLBob
Icon for Resolver II rankResolver 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
Icon for Resolver II rankResolver 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
    Icon for Resolver II rankResolver 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.