As soon as I click on one of the components in split CI, I want it to filter the trend of that component and show only the specific trend line.
I tried it with highlight and is possible as below. I want this same functionality as FILTER and should not show other lines.
The CI components (%ease of doing business, %proactive contact and %problem resolution) are aggregated measures bar chart (split CI)
so when I tried to create an action filter, the source sheet has the names of 3 measures: %ease of doing business, %proactive contact and %problem resolution but in the target sheet I cant see the same columns to filter on (Field: ease of doing business is raw data column not the same as %ease of doing business).