Show selection from control in a text box

[Beginner]

Hi,

Sorry if this has been covered somewhere else, but is there a way to reflect the selection made in a drop down control in a separate text box?

In this simplified dashboard, I want the selection made in the "Office" dropdown , appear as text next to the "Office Results" text box. (the area in grey)

Show Control Selection as Text (google.com)

I know that if I make a selection in a control, it shows what is being selected within the control, but I do not have enough space to widen my control so it can show the full selection name.

Hope I am making sense:)

[lauratilton]

Create a single column, single row table that contains the Office dimension. Remove header, pagination, row numbering. You'll essentially have a text box that displays what is selected. BUT you'll need to change your drop-down to be single-select since the display will only show one selection.

[Beginner]

Thanks.

I've added a table as you suggested and changed the drop down to single select and when a selection is made, the selected text appears as hoped for. But if I then right click the drop down and reset the "Office" control, (so essentially nothing is selected), the text box still shows a selection. Is there a way to show text, only when a selection is made?

[lauratilton · Accepted solution]

Yes! On the Style tab for your filter control, uncheck "Allow Select All" and give your filter control a default value. It doesn't have to be a value in the drop-down, you can just make the default value "Select an Office" or something like that...which will make the initial selection blank, and a value will only appear when you select an office.

At this point your box may say "no data" when the default is set, but there's a way around this too. Set the default formatting of the table text to be the same color as the background, but then add conditional formatting to the table that when Office is not empty, the table text is visible. (Note that the table setting for Missing Data won't work here; if you set it to "blank" the "no data" will still appear, so that's why you need this workaround.)

[Beginner]

Coooooooll!!!!!!

Thanks a million!

[lauratilton]

You're welcome! I'm glad you asked. I had totally forgotten that I had a workaround for the "no data" message and it's something I could use right now!

[jrdprasad]

Hi Lauratilton,

How to give drop down list selected value as input to input box control?

Please help

Thank you

[lauratilton]

Hm...I think in order to have a value you select from a drop-down appear in an input box control, it would need to be a parameter, not a dimension/metric.