Format Date with Trend Line

[mballerio]

Hello,

I want the date format on X-Axis to be (i.e. 28/01 intead of 28 Jan) while displaying a trend line.

The Trend Line needs the type on X Axis to be"Continuous".

The date format as desired is shown only if the type on X Axis is set as "Category".

Please see images below for better understanding.

Any clue to get the result?

[V-lianl-msft · Accepted solution]

Hi @mballerio ,

Trend lines can only be used in the analysis pane when the dates are continuous.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mballerio , Trend line is auto formatted based on data range and level. I doubt you can do much on the format