Forum Discussion
Helper VBlank values in slicers
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
Helper VSean I've already seen that but as I said there is no blank value to exclude even in the filters. I tried that already....
Community ChampionI 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
- mork
You are correct that did the trick. I was trying to uncheck the blank values from the basic filtering and didn't think to try advanced filtering and choose "is not blank". Thanks a lot!!
Excellent trick!!
vshruti06Advocate IV
This solution is working for me.
- aslan
Helper I
doesn't work.
This solution is now out of date. It's a shame there's no way to override the 'Solved' post since it no longer is appropaite.
