Skip to main content
cancel
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.

Reply
Adil
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

 

 

Picture1.png

 

3 REPLIES 3
Baskar
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 

Adil
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.

 

Baskar
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

Announcements
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

PBI_APRIL_CAROUSEL1

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