Need help adding a trend line to line graph in Power BI Desktop
I'm trying to add a trend line to the following graph and cannot find a way to do this. I have added trend lines to previous graphs without a problem and thought the solution was to turn the title for the Y axis off which makes the line style box appear, and then select the desired line style. That no longer works. I've watched several videos on the Power BI Community website for this but their solutions are based on older versions of Power BI. My version is dated May 2021 and the interface is much different than older versions.
I would appreciate any suggestions for how to turn the trendline property on.
I would appreciate any suggestions for how to turn the trendline property on.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Tom: thank you for your response. My X axis is shown as the article recommends (continuous, not categorical). My date field is formatted as m/d/yyyy, same as what I've used before. While this doesn't solve my problem I made a copy of the article for future use because it contains good information.
Subodh: Thank you! That is exactly what I was looking for. I don't know why I didn't try that icon but I'm grateful for your help!
Subodh: Thank you! That is exactly what I was looking for. I don't know why I didn't try that icon but I'm grateful for your help!
Looking further into it, your problem may be in the month-year axis. I had a similar problem while testing, and changed the axis from month-year to year. After doing this, my trend line option showed up.
Sorry I didn't see this had been resolved.
Sorry I didn't see this had been resolved.
ASKER
Thanks for the advice. So far my trend lines are appearing without any modification to the date field.
You're welcome! Glad I could help.
Power BI
Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.
772
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Where’s the Trend Line in Power BI Desktop? | Under the kover of business intelligence (sqlkover.com)