4 Replies Latest reply on Oct 19, 2018 5:45 AM by Jessica Strein

    Use Action Filter to only filter part of a chart

    Jessica Strein

      I am trying to create a dashboard that filters a line graph based on the member selected in the table above it. However, I want to be able to have a baseline line of the average "severity" for all members remain unfiltered on the line graph, so that there is a point of comparison between the singular member and the total group. I can achieve the single measure filtering through using a parameter in a calculated field to filter just the one line, but I don't know if this is possible to do based on a click on another graph. You can see how I use the parameter in Sheet 1 (workbook attached, version 2018.1.5), and Dashboard 1 shows what I would like it to eventually look like, but without an action filter in place. The top chart has a list of members, which is what I want to be able to click to filter the bottom graph. Is there any way to have a total average line remain on the bottom graph unfiltered? Thanks.