Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@wchiu , Can add filter once more and remove is blank and check if it works
@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.....
@wchiu , Can add filter once more and remove is blank and check if it works
Thanks mate! It works!!!!!!!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |