Growth Line Bar Chart (Linear)

Hi Anonymous ,

According to your description, you want to get the target value based on the 10% growth every month.

If so, I have created a data sample:

Please use the following formula to create Target measure:

Target = 
var _minDate=MINX(ALL('Table'),[Date])
var _minValue=CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Date]=_minDate))
var _monthDiff=DATEDIFF(_minDate,MAX('Table'[Date]),MONTH)
return _minValue  * POWER(1.1,_monthDiff)

And then create a Line and stacked column chart:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.