I want to have a title in the dashboard that will reflect the value selected in the filter.
Here is the screenshot of the sample workbook:
On the right side is a Single Select drop-down and the title in Blue reflects that selection. Except that I also want the title to show 'All' when All is selected from the drop-down.
At the moment, the title us just a worksheet, but of course when you select 'All', then all of the values are displayed, I just want it to say 'All'.
Is this possible?
I have attached a sample workbook.
Thanks
Hi Leo-
Move region from rows to the marks card.
Change the mark type to polygon and turn off the row and column borders.
Insert Region in the Worksheet Title. I added Region: in front of it.
Put the sheet in your dashboard and make it fit width.
9.2 attached.