I have a filter named intake which affects all the charts on the report. Of all the charts I want intake filter to exclude and not affect Chart 4 as seen in the image. I have two more filters named sub region and org to affect all the charts including chart 4, only when I use intake it should not filter Chart 4 and all the data should be present as is for Chart 4. I have used a single data source for all the charts.

I did the following steps:
Now your data in Chart 4 should stay untouched when you apply a filter since it's grouped with Charts 1-3. It's kind of a pain when you go back into Edit mode since data becomes grouped and harder to modify, but this was the best solution for me.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With