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

kv's avatar
kv
Icon for Advocate I rankAdvocate I
9 years ago

Ok found a workaround using a page level filter. But still a bit concerned why the Blank is showing up in the first place

  • HansTheEnforcer's avatar
    HansTheEnforcer
    Icon for Helper I rankHelper I
    9 years ago

    The Page level filter workaround does work, OP should mark as a solution