3 of 3 people found this helpful
Hi Eshwar, is it your intention to allow users to look at multiple sheets simultaneously (which is what happens when more than one 'button' is selected at a time)?
If not, you can use a sheet selection parameter, as shown in the attached workbook, dashboard 2. Not sure how fancy you can get with parameter formatting, but at least you'll get the 'one-button-at-a-time' effect I think you're looking for.
1 of 1 people found this helpful
Thanks for the reply. I tried with option. But with this approach, i can put all three options in a single row.
I want that radio buttons in a single row. As that is not possible, i approached text boxes with actions.
If there is way to select parameter radio buttons to keep in single row, Please let me know.
2 of 2 people found this helpful
1. For highlighting the selection with desired colors
Unfortunately, as of now we don't have control over highlight colors of the 'selection' or 'not selected' part (light sky blue color)
2. For clearing the selection and showing only selected sheet:
I have attached the improved workbook. This solves your problem of clearing the selection. When you select one option, the other gets deactivated/cleared automatically and accordingly the sheets below get replaced according to the desired selection. If nothing is selected (just in case all the selections get cleared by mistake), it will show sheet as per the last selection. (I have added the titles for this 'all selection clear' possibility. You can add a suitable title via calculated field)
Please check and let me know if this solves your difficulty.