Forum Discussion
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 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.
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.
3 Replies
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.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
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.
