# Supporting and Excluding action in the line chart **URL:** \ **Category:** Q&A\ **Tags:** interactivity, feature-request, Business-Intelligence-Engineer, quick-sight\ **Created:** [July 16, 2024, 5:28pm UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664 "2024-07-16T17:28:23Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![samytar97](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@samytar97](https://community.amazonquick.com/u/samytar97)\ **Post date:** [July 16, 2024, 5:28pm UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/1 "2024-07-16T17:28:23Z")
Hello, I have a line chart visual with 6 calculated field like average processing time, average delivery time, average Q time . I m trying to support two different actions. The below scenarios mentioned are to be used post the publishing of dashboard. 1. So for all the 6 calculated fields I have added legends to categorize them separately. Lets say I click on Average Delivery Time in the **Legend** then only the selected value should be highlighted in the line chart and others should get dimmed and like wise if I click on Average delivery time in the line I would like to focus only in the selected item. While I did some due diligence I m unable to identify it. 2. In the pie there is an option of excluding few data points while clicking on the pie similarly do we have an similar feature which is available in the line chart. ---
**Author:** ![Deep](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/deep/32/14783_2.png) [@Deep](https://community.amazonquick.com/u/Deep)\ **Post date:** [July 17, 2024, 12:59pm UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/2 "2024-07-17T12:59:27Z")
Hello Samyukth, You can focus on or exclude any line on the chart, except in the following cases: - You create a multi-dimension line chart and use a date field as the dimension for the line color. - You create a measure or multi-measure line chart and use a date field as the dimension for the X axis. In these cases, you can only focus on a line, not exclude it. Focusing on visual elements - [Focusing on visual elements - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/focusing-on-visual-elements.html)) Excluding visual elements - [Excluding visual elements - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/excluding-visual-elements.html). I am not sure if this is what you are looking for … see below (this creates a filter and u can disable the filter if you want all the lines to appear not exactly the same but close to it. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/9/09512eb7ec81e75ef536a838050a92f2eea3cae4.png) Hope this helps. Cheers, Deep ---
**Author:** ![samytar97](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@samytar97](https://community.amazonquick.com/u/samytar97)\ **Post date:** [July 17, 2024, 5:51pm UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/4 "2024-07-17T17:51:20Z")
Hi, Yes I m expecting the same thing as mentioned above however I m unable to get the similar feature in my dash. Is it because I have created a measured line chart and in the x - axis I have an date column. Also as you mentioned that I wont be able to exclude it in the case of multi-measured line chart however I m unable to focus out a one single line. ![WhatsApp Image 2024-07-17 at 9.47.23 PM](https://d1wl4jav5dp96l.cloudfront.net/original/3X/2/2/2275dea757d41991b1e292a40f78d2d611a78422.jpeg) ---
**Author:** ![Deep](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/deep/32/14783_2.png) [@Deep](https://community.amazonquick.com/u/Deep)\ **Post date:** [July 18, 2024, 6:59am UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/5 "2024-07-18T06:59:49Z")
Hello Samyukth, I guess you would need select - Enable adhoc Filtering while publishing. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/3/a/3a47b46f5e87539e2f45106757e731ad09d6a29e.png) you should be able to have the focus option. hope this helps. Thank you. Cheers, Deep ---
**Author:** ![samytar97](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@samytar97](https://community.amazonquick.com/u/samytar97)\ **Post date:** [July 18, 2024, 9:00am UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/6 "2024-07-18T09:00:13Z")
Hi Deepak, While I have already enabled ad-hoc filtering however since I have added the average delivery time, average processing time and others in the value section I m unable to single out one single measure separately. Is there an workaround for this? @Deep ---
**Author:** ![Deep](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/deep/32/14783_2.png) [@Deep](https://community.amazonquick.com/u/Deep)\ **Post date:** [July 18, 2024, 9:50am UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/7 "2024-07-18T09:50:59Z")
Hello Samyukth, To be honest i don’t know… are these 6 fields coming from the single measure field ? if yes you could use as it is in ‘Value’ and create a single calculated field for legends using ifelse and use that in ‘color’ Hope this can be done in your case. Thank you. Cheers, Deep ---
**Author:** ![samytar97](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@samytar97](https://community.amazonquick.com/u/samytar97)\ **Post date:** [July 18, 2024, 10:28am UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/8 "2024-07-18T10:28:25Z")
No these 6 fields or lines coming up from inserting them in 6 different values in the line chart. As you mentioned if else could be used how to go about it? @Deep ---
**Author:** ![Deep](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/deep/32/14783_2.png) [@Deep](https://community.amazonquick.com/u/Deep)\ **Post date:** [July 18, 2024, 10:49am UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/9 "2024-07-18T10:49:59Z")
Hello Samyukth, Yes that i got that you are using it in as 6 different fields in value that is why its does not work. what i meant is having 1 field in value… if the source of these 6 calculated fields is a common field. and get segregated by color (legends) with ifelse. Hope its clear. Cheers, Deep ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [July 26, 2024, 3:27am UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/10 "2024-07-26T03:27:08Z")
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community! ---
**Author:** ![samytar97](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@samytar97](https://community.amazonquick.com/u/samytar97)\ **Post date:** [July 29, 2024, 4:41pm UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/11 "2024-07-29T16:41:29Z")
@Xclipse @WLS-DM This has not been solved. Could you please help in providing a detailed instruction on how to achieve the above issue? ---
**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\ **Post date:** [July 29, 2024, 10:12pm UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/12 "2024-07-29T22:12:00Z")
Hello @samytar97, I believe you are running into a limitation in regards to the line chart visual. Not every visual has the same functionalities on click. Due to this, if you want to maintain some form of onClick functionality, you could try setting up a navigation action that would set a parameter to filter the visual based on the line you are clicking. You would just set the current sheet as the destination so it doesn’t move the user to a different sheet. > **[Using custom actions for filtering and navigating - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/quicksight-actions.html)** > > To add interactive options for dashboard subscribers (QuickSight readers), you create custom actions on one or more visuals in your analysis. Enhancing dashboards with custom actions helps people explore data by adding more context from within the... Alternatively, you may just need to set something up with a parameter control to manage the visual display. Since this functionality isn’t currently available in Quick Sight, I will tag this topic as a feature request. Let me know if you have any remaining questions! ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [July 30, 2024, 3:04am UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/13 "2024-07-30T03:04:38Z")
Hi @samytar97, sorry, currently this is not possible but we are marking this for feature request. At AWS, their roadmap is primarily driven by customers. Your feedback helps them build a better service. I have tagged this as a feature request. More features are being added on a regular basis, so please keep an eye on the [What’s New / Blog](https://community.amazonquick.com/c/announcements/). You can set up a Watching Alert by clicking on the bell icon. You could look to opening up a case with AWS and see if they can provide a solution. Here are the steps to [open a support case](https://docs.aws.amazon.com/awssupport/latest/user/case-management.html). If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps! ---
**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\ **Post date:** [August 1, 2024, 10:21pm UTC](https://community.amazonquick.com/t/supporting-and-excluding-action-in-the-line-chart/32664/14 "2024-08-01T22:21:35Z")
Hello @samytar97, since we have not heard back from you, I wanted to check in and see if you have any remaining questions on this issue. If we do not hear back from you in 3 days, I will archive this topic for our support team. Thank you!