cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User I
Super User I

Re: Trend Lines

@phillip786 as far as I can tell the current trend lines are just the initial implementation, not the complete support they eventually plan. Seems to be the pattern with Power BI development: they release a feature as soon as the minimum usable version of it is ready rather than waiting until they have a more finished product. It's good because new features show up relatively quickly and we can provide feedback earlier in the development process, but bad because now I have a program full of half-features that I want but can't use yet.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
olebor Helper I
Helper I

Re: Trend Lines

you can use trend line on quarter level just with Quarter number. 

 

Super User I
Super User I

Re: Trend Lines

@olebor sure technically you can but it's ugly at best, and worthless if you're looking at more than one year. You have to set the x-axis to "continuous" for trendlines to work, so the chart will only show auto-generated increments on that axis rather than the actual quarters.

 

Trendline.PNG

 

As you can see, Acme Inc. was doing really well in Quarter Zero of 2016, a major improvement over the nosedive they took in Quarter Five of 2015.

 

Not to mention how bad it would look even if you could see the individual quarters labeled on the x-axis.

 

Quarters.PNG

 

If I labeled quarters like that in a report that my execs have to show to other people, they would start wondering what they pay me for. But labeling it this way disables the trendline feature anyway, so fortunately it isn't even an option.

 

Good thing there are ways of manually calculating trendlines, because this feature is still mostly useless.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
olebor Helper I
Helper I

Re: Trend Lines

@KHorseman yes, I know is ugly and that it cannot be used as something that you can show to top management. And as well as all the facts that you have described below. 

I've just wanted to show that Quarters  (as numbers) is working and with quarter labels as we all know it is not working. Because of this issue our customer will not use Power BI vizualization, but Excel chart. 

I am looking forward to solution of the issue. 

Super User I
Super User I

Re: Trend Lines

@olebor yeah I didn't mean to just turn my nose up at your idea. It's just frustrating because your suggestion highlights the fact that trendlines are a functional feature, but they are only half-implemented. Sometimes I'd rather the developers wait a little longer and release a more finished feature.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Super User IV
Super User IV

Re: Trend Lines

@KHorseman - There have been some significant changes to the analytics in the August update, you might want to check again. Although you still need the X-Axis to be set to Continuous and not Categorical. 

 

Can you just turn off the X-Axis and label it with text boxes the way that you want it to look? Something else to think about, you could pick a date for each quarter and have a calculated column to assign that date, so Q1 2015 could be 1/1/2016, Q2 could be 1/2/2016 and so on. Create your line chart using that date as your X-Axis. Now you can set it to continuous. Turn off the X-Axis so that it doesn't display. Create the labels that you want with text boxes.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User I
Super User I

Re: Trend Lines

@Greg_Deckler text boxes could work for some cases, but they wouldn't help if you needed drilldown on a date hierarchy, and even if not you would still need to go in every quarter and rearrange the chart to add a new text box. But as a short-term solution it's not bad. Anyway my end users are picky about the height of tiles in their dashboards; labeling quarters in some style other than "Q1 2015" will definitely be met with "The report is fine. Fix the quarterly chart and we'll start using it."

 

As for the August update, I gather you're talking about the new Analytics Pane? Looks cool. It all seems to work even on a text axis, so that's progress. No trend option though. I just gave it a quick look though, so maybe I missed something. I'll have to check it out in more detail next week. I haven't had much of a chance to play around lately. I'm getting buried alive by this monster data model that they keep radically changing the requirements on. The relationship window is starting to look like a plate of spaghetti and it takes three minutes just to add a new measure. I'm scrapping it completely and starting over clean today. Oh look, the August update has auto-recovery. I could have used that a couple of days ago...

 


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Super User IV
Super User IV

Re: Trend Lines

No problem, we're all crazy busy it seems. The trend line is there in the Analytics pane, but it only shows up if the x-axis is set to Continuous, sort of like before. And I completely agree that a hack of a solution is really no solution at all!!


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
elf_ranger91
Frequent Visitor

Re: Trend Lines

The trend line option still does not appear for me...

 

Instead of using month names on the x-axis, I´m using numerical values as was suggested in this thread. Furthermore, the type is set to continuous - but still having no luck!! 

 

Any ideas?

frankkinsey
Frequent Visitor

Re: Trend Lines

Oddly PowerBIs auto generated insights has this in its visuals but I can find no way of doing this with your own data. Am I doing something wrong?PBI correlation line in insights.PNG

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors