Forum Discussion

Adil's avatar
Adil
Frequent Visitor
9 years ago

Scatter chart Y axis based on sliced different measure values

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

 

 

 

Need Help

3 Replies

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    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's avatar
      Adil
      Frequent Visitor
      9 years ago

      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's avatar
        Baskar
        Icon for Resident Rockstar rankResident Rockstar
        9 years ago

        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.