# Display Column Value in Chart Title **URL:** \ **Category:** Q&A\ **Tags:** quick-sight\ **Created:** [December 22, 2022, 7:44pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652 "2022-12-22T19:44:10Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Ops\_Expert](https://avatars.discourse-cdn.com/v4/letter/o/e19b73/32.png) [@Ops\_Expert](https://community.amazonquick.com/u/Ops_Expert)\ **Post date:** [December 22, 2022, 7:44pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/1 "2022-12-22T19:44:10Z")
I am trying to create a Title that will include a dynamic column value based on the chart filter. Example: ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/bfea69f8fdf32839795eb2e0b2ed772ce5e466d1.png) Tried using Parameter and assigned column field to it, but that didn’t work 😕 ---
**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\ **Post date:** [December 22, 2022, 8:32pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/2 "2022-12-22T20:32:38Z")
You can change the title but you can’t dynamically hide / remove a column. You could look into dynamically hiding / showing visuals. > **[Conditional rules - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/conditional-rules.html)** > > Use conditional rules in Amazon QuickSight. ---
**Author:** ![Ops\_Expert](https://avatars.discourse-cdn.com/v4/letter/o/e19b73/32.png) [@Ops\_Expert](https://community.amazonquick.com/u/Ops_Expert)\ **Post date:** [December 22, 2022, 9:08pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/3 "2022-12-22T21:08:57Z")
I’m not attempting to hide the column. The attached snapshot was just to explain my use case. I just wish to **display the filtered condition in the title**. i.e. If I select John Doe, accordingly his name would display in the title, as **“Transactions for John Doe”** instead of _Jane Doe_ When I used Parameters to achieve this, the table filters the data correctly BUT the title still shows **“Transactions for All”** by default, even if a specific name is selected i.e. filter isn’t working. That’s where I need help ---
**Author:** ![Koushik\_Muthanna](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/koushik_muthanna/32/3290_2.png) [@Koushik\_Muthanna](https://community.amazonquick.com/u/Koushik_Muthanna)\ **Post date:** [December 22, 2022, 9:45pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/4 "2022-12-22T21:45:43Z")
Hi, Please test the following steps 1. Create a parameter 2. Create a control using that parameter ( I am selecting the values from the dataset for filtering data ) 3)Use the parameter for filtering the data ![Screenshot 2022-12-22 at 22.44.16](https://d1wl4jav5dp96l.cloudfront.net/original/2X/4/46018eacb6cfbf4a523895e2e991b8a12c247abe.png) 4)Use the parameter in the title as well ![Screenshot 2022-12-22 at 22.45.11](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/6a06514fecc26d9305bb01d7c5fcbab48ad8f53d.png) ---
**Author:** ![Ops\_Expert](https://avatars.discourse-cdn.com/v4/letter/o/e19b73/32.png) [@Ops\_Expert](https://community.amazonquick.com/u/Ops_Expert)\ **Post date:** [December 22, 2022, 10:48pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/5 "2022-12-22T22:48:18Z")
I did the exact same thing. There are a total of 57,000+ unique names and they do not show up in the list for some reason. Is that why the default always shows All, because the list is too huge? ---
**Author:** ![sagmukhe](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sagmukhe/32/22033_2.png) [@sagmukhe](https://community.amazonquick.com/u/sagmukhe)\ **Post date:** [December 23, 2022, 6:22am UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/6 "2022-12-23T06:22:56Z")
Hello @Ops_Expert - Please follow the below steps and let me know. I tried to simulate your problem at my end and was able to solve it. Hope this helps! ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/682025c55e720bacc9f181fe836c1cc524eba759.png) _Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!_ ---
**Author:** ![Ops\_Expert](https://avatars.discourse-cdn.com/v4/letter/o/e19b73/32.png) [@Ops\_Expert](https://community.amazonquick.com/u/Ops_Expert)\ **Post date:** [December 23, 2022, 4:43pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/7 "2022-12-23T16:43:00Z")
Thanks for the detailed explanation. I’ve been doing the same steps to get the results. However, my use case is: Title based on Interactivity between 2 tables. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/6/634a33140778f8f70ff65e3e9038e3269317e115.png) The title I need to be dynamic is **“Transaction details for $_ClientName_”** by default it’s always **“All”** I have - 1. Enabled Actions between TableA and TableB. The Data filters perfectly. 2. Added parameter $ClientName to the Filter section in both tables as well(values pulling from source dataset). **And this isn’t working** What works: When I pull control on the sheet and select-the title updates. What doesn’t work: When I select the same value in TableA ; for TableB- **the title doesn’t change** I hope this is clear ---
**Author:** ![Jesse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jesse/32/177_2.png) [@Jesse](https://community.amazonquick.com/u/Jesse)\ **Post date:** [January 6, 2023, 6:18pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/8 "2023-01-06T18:18:47Z")
Hi @Ops_Expert - I think you are close. Rather than using a Filter Action between the two tables, use a Navigation Action, which is typically used to send the user to another sheet, however can also be used to set a parameter value on the same sheet. In the action set the value of your ClientName parameterequale to the actual clientname field used in that first table. Assuming you also have set up the filter on the 2nd table to be driven by this same parameter, the filter will still apply, and the title should update too. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/f/f896fdd100c66e5dfb6b1ed43e5f4e3e3982ee96.png) after clicking the +, set like this: ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/29e816fbc0f4fdf69aec206a74fc0d288acc7e9f.png) ---
**Author:** ![Ops\_Expert](https://avatars.discourse-cdn.com/v4/letter/o/e19b73/32.png) [@Ops\_Expert](https://community.amazonquick.com/u/Ops_Expert)\ **Post date:** [January 9, 2023, 10:27pm UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/9 "2023-01-09T22:27:50Z")
That worked well! Appreciate the response. Only problem - I’m trying to do 2 things - filter data + change the title. I am able to add just one select action at a time, but not both. When I tried adding second action to accommodate the title change, I get the message - “Limit 1 select action per visual”. ---
**Author:** ![hexiangw](https://avatars.discourse-cdn.com/v4/letter/h/7993a0/32.png) [@hexiangw](https://community.amazonquick.com/u/hexiangw)\ **Post date:** [December 27, 2023, 6:24am UTC](https://community.amazonquick.com/t/display-column-value-in-chart-title/8652/10 "2023-12-27T06:24:35Z")
Hi I got the same issue, only one select action per visual, do you find out the alternative solution?