Filtering on a dimension from a PICK list, filters on all, instead of just the returned dimension
I have a dynamic dimension I use in a bar graph, based on the value of a variable. This variable gets set by the end-user's choice of KPI to focus on. It is used to change colour schemes, show/hide measures in tables etc... All works fine.
However when I click on a bar in the bar graph using this dynamic dimension (see code below), it doesn't just filter on the "active" dimension, but on all.
So for example, if the vKPI variable = 'Revenue', the dimension returned would be [Revenue Growth % Bracket]. If I click on a bar, eg the "1 - 10%" bracket, my dataset gets filtered on all 8 bracket dimensions:
FilteringThe result in the selections bar
How can I limit the filter action to only filter on the selected dimension from the pick list?