Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Visualisations blank until something (multiple values) selected in a slicer

Hi,   I am trying to display blank visuals until user make a selection from the slicer. Using the below two metrics I can make the visuals blank and display the data with single selection but my ch...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    You can follow below steps to achive your requiremetn:

     

    1. Create a measure to mark tag based on selected records .

    Using Cross Filter: = 
IF (
    COUNTROWS(ALLSELECTED ( 'CALENDAR' )) <> COUNTROWS(ALL ( 'CALENDAR' ))
        && COUNTROWS ( ALLSELECTED ( 'CALENDAR' ) ) > 1,
    "Y",
    "N"
)

     2. Add above measure to visual level filter, then switch filter mode to 'is' to filter "Y" tag.

     

    Result:

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

You can follow below steps to achive your requiremetn:

 

1. Create a measure to mark tag based on selected records .

Using Cross Filter: = 
IF (
    COUNTROWS(ALLSELECTED ( 'CALENDAR' )) <> COUNTROWS(ALL ( 'CALENDAR' ))
        && COUNTROWS ( ALLSELECTED ( 'CALENDAR' ) ) > 1,
    "Y",
    "N"
)

 2. Add above measure to visual level filter, then switch filter mode to 'is' to filter "Y" tag.

 

Result:

 

 

Regards,

Xiaoxin Sheng

motyagi's avatar
motyagi
Helper I
8 years ago

This doesn't work for me :(

Cause I amgetting N for every row