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 tables and change the names of the duplicates. I did that in order to test some transformations and implement some more data. Immediately after duplicating the tables a blank value appeared in all my existing slicers. the tables have no blank values in them. NONE. Not even the duplicated have blank values. The slicers are exactly the same and no other setting is changed except that I placed the two duplicate tables in a separate group in data view.

 

I figured I will just have to filter the blank values out. But trying to apply a filter in the report leve filters section there is no blank values to cross out. only the values of my tables. Yet the blank values are still there in the slicers. What should I try?

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

16 Replies

  • 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

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

    Ok this is a bug and needs resolved asap. Is there a way around filtering that blank out????

     

    Ironically it only appears on new visualizations being created. Existing ones don't display the buggy (Blank) value

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

      Sean I've already seen that but as I said there is no blank value to exclude even in the filters. I tried that already....

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        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

         

         

         

  • 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.