Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello folks,
I have a strange issue. I have two Line charts where the only difference is that one shows months and one shows days (the same date field used). The one that shows months has trend line in it. The daily chart doesn't have the trend line option. I do not understand why?
The bottom one has a month slicer. That is the difference. The date column in top one has Year-Month on the axis. The bottom one has the same date column but month-day hierarchy.
Does anybody have any idea why trend lines not avialable for the bottom one?
Thanks,
Stan
It happened to me with graphics that I already had made to which I tried to add tenedencia line obtaining the same problem. I solved it by deleting the graph and creating it from 0, in this way the options of tenedecia and forecast appeared to me as if by magic.
Hi @Anonymous ,
Not exactlly.
Based on my test, trend line is not supported for text column, date or number is supported.
Best regards,
Jay
I am using a date column in my X axis. The hierarchy is month-day. With that there is no trend line. If I drop the month leaving just the day I see a trend line. But this is what makes it more complicated. I have another line chart where I placed year-month from the same date column and there is a trend line. So the behavour is inconsistent if you think it only works with one level of hierarchy.
@Anonymous for trend line you have to have date on x-axis, and I guess that is why the top one is working and the bottom one is not.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |