clustered column charts that change values when filters are selected

[CL7777]

Good morning

I need to make a clustered column chart that re-calibrates the axis and the the columns when filters are selected on the dashboard. Right now, the clustered column chart shades the total column the amount represented by the filters. When the shaded amount is much less than the total, you cannot really see the values. Why cant clustered column charts just show the values for the selected filters instead of shading it as part of the total.

For example, here is picture of my dashboard with no filters selected

Note the clustered column chart in the top right

Now, here is a picture with a product selected in the dashboard

As you can see, the clustered column chart is shaded with the filtered values and it is very difficult to see the actual revenue values and the trend of these shaded values over time. How can I set the clustered column chart to just show the values for the product selected (with new y axis values) instead of showing it as a shaded percentage of the total revenue from all parts?

[CL7777 · Accepted solution]

I just figured out the solution so Ill post it for others.. 

Click on Edit interactions under Visual Tools-> Format. Then click on the visual that is doing the filtering. In the top right, select filter (instead of highlight). It is the left most choice of the 3 that you are given

Now it will dynamically change the Y axis to be the correct range for whatever filter is chosen