Skip to main content

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:

Dashboard title to replicate filter - single selection or All

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

3 answers
  1. Mar 14, 2016, 11:46 PM

    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.

     

    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.

     

    pastedImage_1.png

    pastedImage_2.png

    9.2 attached.

0/9000