How to display the end of month dates on the line chart for the x-axis?

[cooksa]

I have a line chart that uses end of month dates but the dates are displayed as first of each month?

On the line chart, the presentation uses Stacked area, the measures use a modifier with full accumulation, X-axis uses a continuous scale.

If I turn off the continuous  scales, it shows the dates on vertical axis.

The end of month dates are generated using the following code:

//generating end of month dates

Timeline:

Load

       If(Today()=MonthEnd(today()), today(), monthend(today())) as EOMDate

AutoGenerate 1;

Load

      MonthEnd(Today(),+RecNo()) as EOMDate

autogenerate 36;

Does anyone know how to display the end of month dates on the line chart for the x-axis?