Dynamic text box / basic value

[JoosePekkarinen]

Hi, If anyone could help with quite specific case.

I have a report that is linked to a SharePoint list for additional information. The box shows a row specific information when one is selected. Is there a way to have a basic (or chosen) value for the text box when no rows are selected:

It seems that now the "basic" value is just a random row from the list. I created a dummy row at first and it worked well at the beginning but now the "basic" row is seemingly a random row that changes from the list. It is a bit challenging to give a file because of the SharePoint connection. I tried to play with measures to show the oldest row but didn't get is to work. Don't need a specific code but some ideas how to customize the basic value. Sorry about the redactions.

[halfglassdarkly · Accepted solution]

Try using

SELECTEDVALUE('Table Name'[Field Name],"Alternate text to display when a single value isn't selected")

[JoosePekkarinen]

Thanks! This works.