Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago
Solved

Blank values in slicers

I have a report with a few slicers on it. The slicers were showing just my table values up until recently. I have two tables that I use to construct visualizations etc. Today I duplicated these two t...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    I know there are NO Blanks in your data it used to happen to me only with Slicers.

     

    I wonder if they fixed this because I don't encounter this issue anymore

     

    Are you using => PBI February 2016 version? It seems it doesn't happen anymore

     

    Anyway Select the field you want to use for the Slicer but create a Table first

     

    Then go to Visual Level Filters and Select is not blank

     

    Then convert this visual to Slicer

RalstonT's avatar
RalstonT
Icon for Helper I rankHelper I
7 years ago

Hi,

 

While this may remove the blank option from the filter, it does not keep the date that is assocaited with that filter.  I have data that has all the appropriate information, but still shows as blank.  If I page level filter out blanks this information disappears because it recognizes as blank for some reason.