Forum Discussion
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 I filtered this column to zero , Power BI will always return the union result 0 and blank.
I have done some research on this topic and I know Power BI had some issue with zero , blank and null.
Moeroever, I have lots of column in similar situation ,I don't really want to add any extra column or measure to enable this basic feature.
Do you guys have any idea?
wchiu , Can add filter once more and remove is blank and check if it works
4 Replies
- amitchandak
Super User
wchiu , Not very clear.
In DAX you can check isblank([Column/meausre]) for blank
in Power query you can check
if [col] =null then
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
wchiu , Can add filter once more and remove is blank and check if it works
