Line Chart Date Display

[thomas_2583]

Hi, 

I have a date variable 'Start_Date) which is formatted as DD/MM/YYYY.

Within my Line chart in my dimension, I have amended the date format to show MM YYYY:

=Date(Start_date(Date#(call_date,'DD/MM/YYYY')),'MM YYYY') 

However, my line chart still shows the date as DD/MM/YYYY within the X axis, any idea how to show as MM YYYY please?

[Kashyap_R · Accepted solution]

Hi

Try this

Variable start_date = Date(Date#(call_date,'DD/MM/YYYY'),'DD/MM/YYYY')

In dimension  Date($(start_date ),'MM YYYY')

or

In dimension  Date(Date#(call_date,'DD/MM/YYYY'),'MM YYYY')

Hope this helps 

Thanks