Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
bergen288
Helper III
Helper III

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

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.

bergen288_0-1689622637603.png

 

1 ACCEPTED SOLUTION
bergen288
Helper III
Helper III

@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.

View solution in original post

4 REPLIES 4
AbhinavJoshi
Resolver III
Resolver III

Happy to hear that!

bergen288
Helper III
Helper III

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

bergen288
Helper III
Helper III

@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
Resolver III
Resolver III

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! 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.