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.

SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

Did anyone submit this as a ticket?

Though it is not quite an error, but there should be a table relationship related option to choose whether to show blanks or not.

  • csatary's avatar
    csatary
    Frequent Visitor
    9 years ago

    Hi,

     

    I have 10 data tables with product information, demand qty and period. those are related with keydata columns created from product and period information.  I used many to one relationsships between the files.
    I use several slicers and all of them are showing blanks, while none of the tables containing blanks.

    Moreover in the visuals (charts) also there are blanks and the columns in the visual are showing totally wrong numbers compared to source files.

    I figured out that the sum of the blank columns and the value columns would be the correct numbers. So, I think, there must be a something with data relations.

    this might apply for the slicer blanks as well