Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to plot cumulative target line

Hi, 

How to plot the dotted cumulated target line by using this sample file?

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , In the line plot you can use the markers

    Under Shape-> Line style - Dotted/dashed

     

    Cumulative formula (in case you do have a formula)

     

    Cumm Sales = CALCULATE(SUM(Table[Amount]),filter(allselected(Table),Table[Time] <=max(Table[Time])))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak , I have created cumulative hours measure in the file but it doesn't allow me to add the target line in the chart. Please advise how to do so.