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.
- Ghoom on: Azure Maps Controls -> Selection Greyed out
-
mattlee
on:
Error：Visuals display blank when export report to ...
-
AlenaT
on:
New Button Slicer: Issue with the Grid type of Arr...
-
mattlee
on:
List Slicer Button Dimensions Ignored in Service
-
bhalicki
on:
BUG: report connected to deleted semantic model ca...
- Annamarie on: PBI Semantic Model missing
- SeanGTB on: Azure Map visual auto zoom issue with 3D columns
- Ghoom on: Azure map bubble chart is very blurry
-
JoshT
on:
Deployment pipelines don't support M365 groups
-
Hongju_Jung
on:
A Typo about Measure tools (Korean)