How to add an estimated monthly total on a clustered column chart?

[Rck7]

HI all, 

I am hoping someone could suggest me a way to add a monthly total(i.e. 75000/month) for Fiscal Year 4 on a clustered column chart.   

I have a table with a date cloumn, with data from [October 2015 to October 2017]. Currently, I have the chart with two Fiscal years with total number of tokens used/month comparing Fiscal Year 2 & Fiscal Year 3 (i.e. years: from 27-oct-15 to 26-oct-2016 & from 27-oct-16 to 26- oct- 2017) 

Now, I would like to add a value representing Fiscal year 4.i.e. (from 27-oct-2017- 26-oct-2018)  with a monthly value of 75000 tokes used/month on the same chart. How would I be able to do this? 

Here is the Table structure: 

 
Chart:

 Axis parameters used for the chart: 

Any help would be very much appreciated. 
Thank you!!!!!!!!!!! 

[MFelix · Accepted solution]

Hi @Rck7,

If your value is a fixed value then just add a measure with that value in your case:

Fiscal/Year 4 = 75000

Then add it to your chart:

In the example the the October, November and December don't appear on PY and CY becaus I have values YTD.

Regards,

MFelix

[Rck7]

@MFelix Thank you very much!!!!!!!! It helped 🙂