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?