Values behind the trend line

[s23126]

Hi All,

I need a solution for viewing a value behind a trendline at certain Point.

I have created a visual, on the Y-axis i have the price and on the X-Axis I have the amount of quantity sold, which is nice and then a trendline is calculated it shows me the price performance. The slicers are set on products. However, I was trying to see if i can find a value at 1000 kgs, means i want to know the price at 1000 Kgs on the trendline everytime when i change the selection of the products, also if possible the general discount value which is calculated behind the trendline in this case it would be the quantity discount which is coming out of the data for calculating the trendline. Can anyone suggest a solution for it?

Thank you.

[Greg_Deckler]

Sounds like you need something along the lines of my Linear Interpolation Quick Measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Linear-Interpolation/m-p/330712