Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

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





Resident Rockstar
Resident Rockstar

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 

Frequent Visitor

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.


Resident Rockstar
Resident Rockstar

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.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors