Hi everyone,
I'm trying to add a trend line to a line chart and I can't seem to find the option ...
I used to do it but has the option been removed from the last update ?
If so what are my options to add a trend line ?
Thanks,
Nick
Solved! Go to Solution.
Nervermind I found it,
I just changed my X axis (Months) from categorical to continous,
Nick
For Line Chart, the Trend Line is available only if you have a single Y-axis (and as mentioned, the date X-axis must be continuous).
If you have a secondary Y-axis, the trend line option is not shown.
My use case is showing # of created support tickets (1st Y-axis) and # of resolved support ticket (2nd Y-axis) vs. the date (X-axis).
So it seems that I will need to create a new line chart visual with a single Y-axis using the formula [resolved minus created] and then add the trend line.
@NB3 it still exists depends wht visual and what value you are using on x-axis?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Nervermind I found it,
I just changed my X axis (Months) from categorical to continous,
Nick
User | Count |
---|---|
103 | |
85 | |
70 | |
49 | |
49 |
User | Count |
---|---|
149 | |
95 | |
78 | |
71 | |
68 |