Why (blank) value is also showing up when 0 is selected in target slicer

[bergen288]

I have a table visual with 3 slicers as shown below.  One slicer has (blank) values as some cases are unresolved yet.  As you can see, the (blank) values (the red ? mark)  are showing up when 0 is selected in this slicer.  It works fine with all other non-zero values.  What's wrong with it and how to fix it?

Thanks.

[AbhinavJoshi]

Happy to hear that!

[bergen288]

The issue is addressed after I converted blank to -1.

[bergen288 · Accepted solution]

@AbhinavJoshi 

Column quality and Column Profile shows there are 132 (13%) blank values.  I changed its data type to whole number, but it won't fix my issue.  I am going to convert blank value to -1 to fix the issue.

Thanks anyway.

[AbhinavJoshi]

Hi @bergen288. It could be due to different datatypes. Navigate to Power Query Editor -> View and select Column quality and Column Profile, it will help you to identify the real emtpy values. Also Power BI treats the blank values as zero when you select 0. 

1. In the Visualizations pane, navigate to the Format section.
2. Expand the "Data type" section.
3. Look for the option related to the field used in the slicer that contains (blank) values.
4. Change the "Data type" setting to "Whole number" or "Decimal number" (based on the field's original data type)

Try these, and I hope it helps!