Forum Discussion

hellovaras's avatar
hellovaras
Regular Visitor
7 years ago
Solved

CARD Visualization

Hello - thank you in advance.

 

I want to use the Card visualization to show the result of my filter. The issue I have is that when I choose All in the filter the Card visualization defaults to the first selection of the field. How can I make the Card say "All"

 

Example: 

Filter = All

Card = Braves <- I want this to say "All"

 

Filter = New York

Card = Yankees

 

etc

 

Thank you

  • Anonymous's avatar
    Anonymous
    7 years ago
    Measure for Card =
if(
    HASONEVALUE( Slicer[City] ),
    VALUES( Slicer[City] ),
    if(
        ISFILTERED( Slicer ),
        "Many Cities Selected",
        "All Cities"
    )
)

    Best

    Darek

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Measure for Card =
if(
    HASONEVALUE( Slicer[City] ),
    VALUES( Slicer[City] ),
    if(
        ISFILTERED( Slicer ),
        "Many Cities Selected",
        "All Cities"
    )
)

    Best

    Darek