Showing results for 
Search instead for 
Did you mean: 
amangheewalla Regular Visitor
Regular Visitor

Power BI Null Value Bug

The latest update of Power BI (2.70.5494.562 64-bit (June 2019)) has a crucial bug which I hope Microsoft fixes as soon as possible.  


If you go to Edit Queries and have a column which has a null value.  If you transform that column such as upper case the values in that column, trim that column, etc.  and then after those applied steps, if you try to filter the null value out, it will NOT filter the null out.


It seems Power BI is applying those transformations to a null value (such as trying to capitalise a null value) and that step changes the null value.  When you try to filter after the transformations, Power BI doesn't recognize that it's a null value anymore since it's been tranformed, and it refuses to filter it out.


I've been able to re-create this issue with a colleague as well.  Here is a screenshot.  How do we report this bug to Microsoft?  It has considerably hobbled a production report of mine as this problem didn't exist before this latest update.


Example 1.png


Example 2.png

EOL Frequent Visitor
Frequent Visitor

Re: Power BI Null Value Bug

This bug has also consequences for any date calculates columns. Please fix this Microsoft.

TestingTech Frequent Visitor
Frequent Visitor

Re: Power BI Null Value Bug

I can verify this bug, hope they are able to fix this sooner than later.

Community Support Team
Community Support Team

Re: Power BI Null Value Bug

Hi @amangheewalla ,


This issue would be fixed in the coming new version of Power BI Desktop. Please refer to curth's reply here.


Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.