Quickie update: I've moved my little conditionally- calculated text field to a tooltip. Since I have the filter selections displayed as a row of icons, I made the tooltip appear on hover, and since it's conditional to category=medical, it only appears when hovering over Medical. So that's something, at least, but I have to assume the client wants it to operate as originally envisioned, so still looking for help.
You can pop out a sheet. Make a pop-out sheet that displays only when a specific value is selected. That will push the sheet into view.
Hang on. I'll hack up something in a version you'll be able to open.
OK, in the attached 9.2 superstore example I have a dashboard with 3 sheets.
One is just any old sheet. It shows whatever states are selected in the filter.
One is the special sheet. I want to display it on the dashboard only when Idaho is selected in that filter.
The third is my pop-out sheet. This is the key. I made a calc that sets its value to 1 if only one state is chosen (see [States on sheet]), and if that one state is Idaho (see [Special calc to display ...]). I put that [Special calc to display] on filters and selected for value = 1. Anything else will result in an empty sheet.
The pop-out sheet and the special sheet are in a floating container.
Play with the filter on Dashboard 1. Add another state. You'll see the pop-out sheet go blank, which makes the special sheet shift to the left. Select only Idaho, and the pop-out displays and pops the special sheet to the right.
Now go to Dashboard 2. HEre I positioned the floating container with a negative x-position. When the pop-out sheet collapses, the special sheet goes to the left, off the dashboard view. It's still on the dashboard, technically, but the user can't see it.
You can push things out to the right, or down from the top (with a negative y-position to start.) You can position this floating container to float under other sheets so things pop out from behind that sheet. The possibilities are limited only by your creativity. You can pop out anything you want. I have some dashboards where I pop out an entire sub-dashboard (of sorts) that holds all the filters and parameters because a busy dashboard didn't have enough room for filters and parameters. So one little parameter (hide/show) lets the user get to all the toys to set things on the dashboard.
Since I can't see your dashboard, I can't suggest how to position this concept, but this is the mechanism you can use to pop out a sheet when a certain condition is met.