Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago
Solved

Slicers

  Hi everybody !   I have two little questions about slicers.   Firstly, I would like to know if its possible to do not have the case (Empty) on my horizontal slicer. (circle on the left) ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    HI DavidB023,

     

    When looking at the slicer and based on my experienced this appears because of the model, one way to filter out that is to add a the column you are using as slicer in the report level filter or page level filter and take out the blanks values.

     

     

    Regarding the second part you need to create a measure to calculate the number when all is selected.

     

    Measure =
IF (
    DISTINCTCOUNT ( Slicer_Table[Slicer column] ) = 1;
    SUM ( Table[Column] );
    ""
)

    This will give the result below:

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

HI DavidB023,

 

When looking at the slicer and based on my experienced this appears because of the model, one way to filter out that is to add a the column you are using as slicer in the report level filter or page level filter and take out the blanks values.

 

 

Regarding the second part you need to create a measure to calculate the number when all is selected.

 

Measure =
IF (
    DISTINCTCOUNT ( Slicer_Table[Slicer column] ) = 1;
    SUM ( Table[Column] );
    ""
)

This will give the result below:

 

Regards,

MFelix

  • DavidB023's avatar
    DavidB023
    Helper III
    8 years ago

    Thanks for your answer MFelix ! It's a successful way to resolve my problem,

     

    Best regards

    DavidB023