How to set a default value for a text box ?

[Sravyarajarapu]

Hello all,

I have created a dashboard in powerbi and created a table visual and few text box visuals.  I do not see an option to have a default value in the text boxes and it takes up the least values from the table visual. Example: below are few text boxes 

Name : Jack

Age : 2 

so in my data alphabetically looking 'j' is the least alphabet and the least age is 2 so it is picking it up automatically, so how do I change it, so when none of the table row is selected it should show empty and when I actually select a row in the table visual then these text boxes data changes. As of now it picks up the lease value they have, how do I fix this ? .When I actually open powerbi I want to set the name and age to empty and when I select a row in the table visual these should be changed and when I click on reset then they have to go back to empty . How do I do this ? Can someone please help me with this? 

[Sravyarajarapu]

May I know what works for the numeric values? It returns the result but when none is selected it does not return blank/empty, it returns a eye symbol with a cross on it, how to avoid this? 

 

[RMDNA]

Hi @Sravyarajarapu - by "text boxes", do you mean cards? If so, you could use something like ISFILTERED( ) or SELECTEDVALUE( ), depending on your situation. A measure like SELECTEDVALUE(Name","") will return the result of the specifed field (Name) if it has only one value (from you selecting a row), otherwise it will return blank.

No selection:

With selection

Does this work? Note that if that field ends up with a single value through some other method (a slicer, etc.), it will also return the name.

[Sravyarajarapu]

 hello Sage Thankyou for your reply, I was actually referring to the text box, so if you could see the picture, the blng_date is the table visual and the bottom one is the text box visual and I have added the blng_date in the value. As of now I haven't selected any date in the table but by default the text box is picking the least date available. But if I click on any other date on the multiple dates available the text box date changes. So I wanted to have a default value like Empty in the text box when the date is not selected. Could you please help me with this. The text box filtered is available on the insert option in desktop 

[RMDNA]

You can actually reference the measure I suggested:

When published to the service, it looks like this: 

No selection

Selection

Does that help?

[Sravyarajarapu]

 the isfiltered or the selected value is not working 

[RMDNA · Accepted solution]

@Sravyarajarapu don't write the formula there - write the measure separately in one of your tables like normal, then just reference the measure value in the text box. In your case, the measure would be something like:

mesaure name = SELECTEDVALUE('Table Name'[field name],"")

[Sravyarajarapu]

Thankyou for your help it worked when I created a new measure and used that measure in the text box, it worked for all the text values but I guess the date field has an other formula