Forum Discussion

y3wan's avatar
y3wan
Frequent Visitor
3 years ago
Solved

Default Value on Card Visuals Display

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
y3wan
Frequent Visitor
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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.