Slicer issue with blank values and zeros

[beli]

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

[v-haibl-msft]

@beli

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-msft]

Hi @beli,

I got the information that this is currently by design.

Best Regards,
Qiuyun Yu

[Anonymous]

Finally, I found this. I was going crazy with the behavior of my report.

Is there any update? I think this is an amazing and very serious BUG not to be solved yet by Microsoft team

[Anonymous]

Workaround if anyone reach this:

In Edit Queries, change the column type to Text instead Number.

[PVO3]

I'm not sure what the reasoning is that this is intentional. I just spend an hour to find this old post...

[ugurdemir]

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