Trend line on/off on shared report

[Rolina]

Hi, is there any way to includ on/off button for the trend line for one of the line charts in shared via My Workspace dahsboard?

The chart has zoom slider in X axisis so when user select narrow range, trend line makes no sense, so I am curieous if there is apossibility for users to turn it on or off?

Thanks!

[danextian · Accepted solution]

Hi @Rolina 

Currently, there's no way to turn off trend lines when you zoom into a visual. Trend lines when you zoom in. The workaround is to not use a trend line from the analytics tab but instead create one using DAX (linear regression) and then add a slicer that can be toggld on and off to show the trendline.

Please see the attached sample pbix.

[Rolina]

hey, that responds to my query, thank you so much. I don't have experience in DAX, but maybe i'll try the proposed workaround. Thanks a mil!