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

nisuomi's avatar
nisuomi
Icon for Resolver I rankResolver I
9 years ago

Hi, I am wondering why this workaround does not work for me at all :/ ?

  • Markets's avatar
    Markets
    Frequent Visitor
    9 years ago

    That trick don't work anymore... it changed a few months ago

    • Günter's avatar
      Günter
      Regular Visitor
      9 years ago

      I also have the same issue but I tried to put "field" in the "Page Level filters" and un-select the "(Blank)". 

      "(Blank)" in the visual slicer suddenly dissappeared.

       

      I hope this trick works well for you

       

       

       

      • sekic's avatar
        sekic
        Icon for Helper I rankHelper I
        8 years ago

        Still got this error. I can override it with page selection filter, but this is stil UNSOLVED error :(

         

        What if next year we god new data, but forget to check this selection? Eg. in year 2016 and 2017 we had slicer which uncheck (BLANK) on report level by checking year 2017 and 2017,  but in new year 2018 there will no be data from 2018 (because it's not checked in report level)? Report will be incorrect !!!