Trend lines

[Anonymous]

Hi All,
One urgent requirement. Im trying to get trend lines on line and bar charts but unable to do so. When Im trying to convert data from categorical to countinuous to get trend lines from analytics pane, its not allowing me to do. If you want I can also share my sample data with you. Please help me on it. Date data is like Jan to December and for 5 years. So I get 60 values on X axis. I want to show TREND LINES for this.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, the trend line can be added normally.

First change the X-axis - Type to "Continuous"

Check if having correctly formatted Y-Axis (Date/Number etc.)

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