Scatter chart Y axis based on sliced different measure values

[Adil]

Dear BI Community

I wonder if you can help in solving the issue I have with the Y Axis in this scatter chart with slicers.

based on date selection I need to compute the CAGR for the consecutive years based on the first year in the record that hase been selected in ther slicer. so if I select 2010 through 2015 years the Y axis should adjust automatically and calculate the CAGRs for this period for respective categories.

CAGR = (category value last year selected/ category value first year selected) ^ (1/(last year selected-first year selected))-1

[Baskar]

Cool ,

Right now it was working as u mention. Do u want to show the all selected year instead of 2015 in the chart ?

If yes , u have to remove the Play axis , bec now the play axis in 2015 so only u r getting this value. 

correct me if am wrong 

[Adil]

Hi Bascar 

currently the Y axis values are based on a fixed calculation of CAGR taking 2005 as a base year. I want this to be dynamic based on slicer selection of years.

[Baskar]

If u fixed the y axis value ( like static set of Start and End  )  it won't change dynamically based on your selection.

but it will basically react dynamically based on selection.