Forum Discussion

GGR's avatar
GGR
Regular Visitor
11 years ago
Solved

SLICERS -> blank value

I have a question about using slicers in my report. I make slicer which show the two years, I have just two values in my year table. But I also see blank value , is it possible to hide this one ?  ...
Need Help
  • Anonymous's avatar
    Anonymous
    11 years ago

    adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.

ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
11 years ago

GGR You can filter data while importing using query to exclude blank values. But you won't be able to see associated records with blank value. OR you can rename the blank values to some meaningful name by creating a calculated column. Hope this helps!

  • adamgor's avatar
    adamgor
    Icon for Microsoft Employee rankMicrosoft Employee
    11 years ago

    I have data that has 0 blank values, yet I still see (Blank) on many of my slicers

     

    Any way to fix this?

    • Anonymous's avatar
      Anonymous
      Not applicable
      11 years ago

      adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.

      • adamgor's avatar
        adamgor
        Icon for Microsoft Employee rankMicrosoft Employee
        11 years ago

        Anonymous  Thanks!  I was able to apply a blanket page wide filter such as this, and it has fixed my issue!

         

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

    Hi, I want to replace my blanks into word "Blanks" so that I can show them in the slicer as blanks itself as one line item, is it possible ??

     

    I have list of word in the 1st column 

     

    column1

    Apple

    Bag

    Car

                 <- Blank 

    Echo 

     

    Expecting Output:

    column 

     

    Apple 

    Bag 

    Car 

    (Blank)

    Echo 

     

    Thank you in advance 

    • asreenu's avatar
      asreenu
      Icon for Advocate II rankAdvocate II
      9 years ago

      hmm..I wonder what the PowerBI team is doing if they are not even looking at the feedback.  This is a very visible and simple problem for two years and still not fixed.  How can we trust any MS products?