Hi,
I have an issue when filtering numeric column which has numbers and blank values in it.
Problem is that when using the filter to show only 0 (zero) values, also the blank values will be shown. Selecting/deselecting blanks in the basic filtering has no effect. In advanced filtering applying "is not blank" works however.
Also in basic filtering, if all the values are selected ("Select all") and then clicked one by one (deselecting them) so that 0 (zero) is the only value selected, then matrix shows zero values correctly. Also in this case selecting/deselecting blanks show in the matrix as supposed.
Attach are screen captures of the issue. I have also reproduced it in a simple pbix file which I can send/upload somewhere.
Blanks incorrectly showingBlanks filtered out
6 Comments
v-haibl-msftMicrosoft Employee
I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 28445410
I’ll post here once I get any update about it.
Best Regards,
Herbert
v-qiuyu-msftCommunity Support
PVO3Impactful Individual
I'm not sure what the reasoning is that this is intentional. I just spend an hour to find this old post...
ugurdemirHelper II
This is not only a slicer issue but also dax functions of IF and SWITCH
Example measure=
var _test=[a measure] \\ format as decimal
return
switch(true()
,_test>10,"A"
,_test>=0,"B"
)
In this situation whether [a measure] is 0 or blank Example measure returns B
But if i rewrite it like this;
Example measure=
var _test=[a measure] \\format as decimal
return
switch(true()
,_test=blank(),"blank"
,_test>10,"A"
,_test>=0,"B"
)
then this returns "blank"
this is not reasonable
