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:)
Solved! Go to 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.)
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |