Forum Discussion

leneprd's avatar
leneprd
Regular Visitor
7 years ago
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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Everyone,

v-lili6-msft 

I am attempting this solution, but I am having trouble understanding why is (Table1[Names]) represented 3 times in this measure? 

Table1[Names]
Measure = IF(ISFILTERED(Table1[Names]),FIRSTNONBLANK(Table1[Names],Table1[Names]),"default value")

I have a table of names and I'm using the basic filter pane for searching Customers. When the user selects a Customer, a name will be displayed in the card. BUT, If no Customer is slected,  the card should display a differnt word, i.e. "Default," not the first name in the table.

Please help, it's not working for me!  Thank you!