A (blank) option in the slicer

[Marra13]

I have a table as follows:

KeyYM   Label

202105   May-2021

202104   Apr-201

202103   Mar-2021

202102   Feb-2021

202101   Jan-2021

The slicer displays the Labels in reverse order but also adda a (blank) option, why?

The filter table has NO blank row and there are NO blank entries in the column KeyYM in the main data table, so why does it do it!?!

[negi007 · Accepted solution]

@Marra13  Please check if one side of the relationship column has non-matching or blank values. That could be reason you have blank in the slicer. 

You can remove blank values by filtering it from the filter option like below 

 thanks,