By using the Insert button on the caption dialog box will allow you to add any field that is on the view in the caption. It will then dynamically change, based on what fields are actually in the view (i.e. if members are filtered out, they will also be filtered out of the caption).
Hope this helps!
I am not sure that is exactly what Ajit is asking...I've been running into the same issue. I have a "Filters" tab where all of my filters are located, and I would like the caption to dynamically change when the user selects various filter options. Currently, to update the caption, I have to hover over it and right-click "Reset Caption". But it would be great if it would automatically do so. If anyone knows of a way to do this, please let me know!
Captions are very similar to Titles, so hopefully this will help:
If either of you can post a packaged workbook example, along with a detailed description of your desired output, I'll be happy to take a look. Cheers!
Thanks Matthew - I have read these posts and while they are helpful, they
don't solve the issue I am having. Let's say I have two multi-select
filters on my dash, with all values currently selected. The
automatically-generated caption would say something like "Filter1 has 10 of
10 values selected, Filter2 has 5 of 5 values selected". If the user
unselects 2 of the values from Filter1, I would like the caption to
dynamically update to say "Filter1 has 8 of 10 values selected, Filter2 has
5 of 5 values selected". Unless I'm missing something, I don't think
there's a way to do this currently in Tableau. I can do it manually (by
clicking "Reset Caption") but it would be more useful if it would update
On Thu, Jun 12, 2014 at 9:01 AM, Matthew Lutton <
Matthew/Tracy - I stand corrected. Using the Insert->Field function in the Caption dialog box (as Tracy suggested) works; it's just slightly different than the automatically generated caption which is why I didn't see it. For example, using this method literally lists the values that are included, so I added some text such that it reads "Filter1 includes <Filter1>." However, it does not say "Filter1 has 10 of 10 values selected". But, it will work for now! Thanks guys!
This is very helpful, thanks Tracy. I also have some measures as filter options. Is there any way to get these measures to show up in the caption?
I would like to know how to get measure filter values into the caption as well.