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

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

vshruti06's avatar
vshruti06
Icon for Advocate IV rankAdvocate IV
9 years ago

This solution is working for me.