Forum Discussion
Solved
How to set default value
Hi, I want to know how to set default value. i have a table of names.. and i'm using a smart filter as search engine. When user search names, a name will be display in "card". But, in defaut mod...
hi, leneprd
You could create a measure like below:
Measure = IF(ISFILTERED(Table1[Names]),FIRSTNONBLANK(Table1[Names],Table1[Names]),"default value")
Then drag this measure into card instead of name field
Result:
don't select any nameselect one name
Best Regards,
Lin
hi, leneprd
You could create a measure like below:
Measure = IF(ISFILTERED(Table1[Names]),FIRSTNONBLANK(Table1[Names],Table1[Names]),"default value")
Then drag this measure into card instead of name field
Result:
don't select any nameselect one name
Best Regards,
Lin
It's work... :heart:
TQSM v-lili6-msft