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 , Not very clear.

 

In DAX you can check isblank([Column/meausre])  for blank

 

in Power query  you can check

if [col] =null then

  • wchiu's avatar
    wchiu
    Frequent Visitor
    5 years ago

    Let me assume like this, I have a table like below 

    When I filtered this value to 0 , blank is also present in the value 


    I only want 0 appears in my table.....

     

    • 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!!!!!!!!!