Show relevant values in dashboard input controls doesn’t work in Edit mode.
Say I have 2 input controls on the dashboard - Country and City, and the listbox dropdown behind City is set to show relevant values. Both Country and City input controls are configured to set a corresponding parameter, which drives a worksheet formula-based filter.
All works great, until the author puts the dashboard into an Edit mode. At that point, the City listbox starts showing all values, instead of only relevant values, creating confusion.
Once you publish the dashboard or discard the draft, all goes back to normal.