Forum Discussion

wchiu's avatar
wchiu
Frequent Visitor
5 years ago
Solved

Power bi cannot distinguish zero and null

Hi Guys,    I have a column that have value null,0,1,2,3,4,5   in a SQL table.  When I am using this column in Power BI , I can see the filter plane have value (blank,0,1,2,3,4,5).  However, when...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    wchiu , Can add filter once more and remove is blank and check if it works

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

wchiu , Can add filter once more and remove is blank and check if it works

wchiu's avatar
wchiu
Frequent Visitor
5 years ago

Thanks mate! It works!!!!!!!!!