Show Future KPI Values

[laetitiaf]

Hi Guys, 

I'm wondering if it's possible to take the overstock value from the first month of this year, divide it by 12 and use to determine the Target value for the next 12 months. 

EG. 
Overstock 01/2025 = $4,658
Target 01/2025 = $4,270
Target 02/2025 = $3,881

Target 03/2025 = $3,493

Target 04/2025 = $3,105

Target 05/2025 = $2,717

Target 06/2025 = $2329

...
Target 12/2025 = $0

(Decline of about $388 per month, but this value needs to be dynamic depending on what filter is used)

Looking for the visual to end up looking like something similar to the below, with the blue line added.

Model looks like below

[danextian]

Hi @laetitiaf 

Possible.  But the approach depends. Please post a workable sample data (not an image)

[miTutorials · Accepted solution]

Take a look at this video - You might have to tweak the dax a little to suit your requirements.

Forecast in Power BI & Display as Overlapping Columns | Power BI Tutorial | MiTutorials - YouTube

[laetitiaf]

Thank you, that video helped me work through it!

Bit of a mess but these are the measures I have ended up with for now.