Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Growth Line Bar Chart (Linear)

Hey!   I am looking for a way to add a linear "target line" to my line/bar chart. What I am looking  for is to use januari Total Sales as a base line and to add a growth line based on a % (determi...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the swift reply, Eyelyn!

     

    Sadly the above mentioned measure returns blank. Could this have to do with how my data structure is set up? (Tabular model)