Default Value on Card Visuals Display

[y3wan]

Hello All,

I have a drop down for store location (City A, City B, City C, & All) with various card visuals that display store selected, store sales and etc....

My goal is to have a default value for my card display as "All" from the Store Location column (when nothing is selected).

Store Location

City A

City B

City C

All

I have attmepted creating a measure of ISFILTERED, but wasn't succesfully.

Your help would be much apprecaited.

[Anonymous]

Hi @y3wan ,

Please try below steps:

1. below is my test table

Table:

2. create a measure and add it to card visual, then add a slicer with "Store Location" column

Measure =
VAR _a =
    HASONEVALUE ( 'Table'[Store Location] )
VAR _b =
    SELECTEDVALUE ( 'Table'[Store Location] )
RETURN
    IF ( _a, _b, "All" )

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[y3wan]

Hi cst

Thanks for the reply.

Is there a way that when nothing is selected manually, the option All will be selected instead?

I think the measure provided was to display the text All

[Anonymous · Accepted solution]

Hi @y3wan ,

I adjust the measure, please try.

Measure =
VAR _a =
    HASONEVALUE ( 'Table'[Store Location] )
VAR _b =
    SELECTEDVALUE ( 'Table'[Store Location] )
VAR _c =
    CALCULATE ( MAX ( 'Table'[Store Location] ), 'Table'[Store Location] = "All" )
RETURN
    IF ( _a, _b, _c )

For this question :"Is there a way that when nothing is selected manually, the option All will be selected instead?", we could only let the slicer option become single by set the "Single select " turn on, could not choose what option to select

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.