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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Show Items with no data in slicer not working

I created a quick repro table:

 

Col1       Col2

Value1   50

Value2   55

              40

 

 

If I create a slicer on Col1, the blank value still shows up in the slicer. The option to "show items with no data" is not selected in field option. There are no relationships to any other table, this was stand-alone table I created using Enter Data, so I know this is not a bi-directional filter issue. Is this a bug? Slicer does not give visual filter option to filter out blank values.

Status: New
Comments
v-jiascu-msft
Employee

Hi @sqlchicken,

 

The blank values should be there. What if you want to filter the blanks? The solution is using a page level filter to excluding the blanks if you want.

Show_Items_with_no_data_in_slicer_not_working

 

Best Regards,

Dale

sqlchicken
Employee

Thanks. The customer I was working with, it turns out the answer was an issue with relationship filter directions. My repro wasn't 1:1 to their issue. Thanks for page level filter tip. I had originally considered that but wasn't sure if they wanted that category to disappear from everything on the page.