Disconnect year slicer from sales CAGR chart

[dc189]

Hi guys,

I have a sales CAGR chart as below that shows growth over the 5 years from 2010 to 2014 for different age and income brackets.

Problem is, I have this chart aloing with other charts on a dashboard and when I filter the year slicer for say, 2014, the cagr chart understandably goes blank. How do I make sure that the cagr chart is "disconnected" from the year slicer only and not other slicers, and all the slicers are connected to all other charts?

I learnt that the ALL function can be used but there's something wrong with my formula below which is still making my cagr chart go blank when I filter for a year in the slicer.

Sales CAGR = ((CALCULATE(SUM(SmCustomerDemographics[Sales Amount]),ALL(SmCustomerDemographics[Year]),FILTER(SmCustomerDemographics, SmCustomerDemographics[Year]=2014)))  /  CALCULATE(SUM(SmCustomerDemographics[Sales Amount]),ALL(SmCustomerDemographics[Year]),FILTER(SmCustomerDemographics, SmCustomerDemographics[Year]=MIN(SmCustomerDemographics[Year])))) ^ (1/  (2014-MIN(SmCustomerDemographics[Year]))  )-1

If someone could point out the mistake in the formula, that would be great! Please note that in the cagr formula above, I've manually plugged in 2014 instead of max(year) because the max year is actually 2015 for which we don't have complete data.

Thanks!

[GilbertQ · Accepted solution]

Hi @dc189

What you could very easily do is to edit the interactions, so that when you click on the Year Slicer the Interaction does not affect your chart?

Click on your Year Slicer, then in the ribbon click on Format (1) and then Edit Interactions (2), then change it from Filter to None

[dc189]

Perfect, thank you!

[Anonymous]

In my page I have 3 charts but I want my YTD chart not interact with the slicer but the other 2 charts should change with Year selection. How can we do this.