Ability to use Trend Line with Categorical Values in X-axis
Right now we can only use trend lines for continuous values in the x axis. It would be great if a categorical value could also be used, such as month name.
Daniel Miradakis commented
PLEASE add this functionality. I have gotten my company HOOKED on Power BI now, and I am doing all sorts of advanced reporting creation (dynamic slicing on visuals, hidden custom slicer pane via Bookmarks, etc.).
However, my end users want to see data in whatever time buckets they choose, and that includes visuals with simple linear regression lines. I LOVE the default and customizable date hierarchies, but the trends lines need to be extended further in their functionality with categorical variables.
If Power BI absolutely requires a continuous variable to plot a simple linear regression line, fine. But please, then, allow us an option to replace the continuous variables on the x-axis with their categorical counterparts, and then implement this feature to be repeated several times for EACH LEVEL of a hierarchy (e.g. Year, Quarter, Month, Date).
This will help our organization so much!
This would greatly enhance the reporting capabilities at our agency!
Cindy Duran commented
Linear trendlines need to be available in Power BI. Our healthcare organization is in the process of converting all of our control charts from QI Macros to Power BI. We were disappointed to learn that this functionality is not available in Power BI. We always apply trendlines to our charts to better display whether the pattern of data points is increasing or decreasing.
Jayden Sanders commented
This is extremely important for our organization
I can understand why this doesn't work in its current state: in order to forecast/trend, Power BI needs to know relative distance between each category value. But regardless, a very common user story is not currently supported. Two possible solutions:
1) Use continuous (not categorical) but force Power BI to display all values of x-axis (not matter how cluttered that makes the visual)
2) Activate Trendline for Categorical, but caveat to user that Power BI will infer equal increment across category values.
Dan Day commented
how is this not a thing?
so much needed...
this is an important feature which would make trend lines SO much easier. Currently not having a continuous option when plotting categories (even if those categories are a custom calendar e.g "2018 P1") is a big pitfall and makes trend lines impossible.
Diana Borina commented
Agree - you have NO idea what cosmic workaround calculations me and my colleague made to get this thing working...
Justin Shands commented
I don't even understand why this doesn't work this way already. It makes sense that the value the trend line is mapping would need to be numerical, but what does it matter how it's split up? If I have 5 number values in a chart, you shouldn't need to know what I call those groups in order to calculate a trend line... it's already divided into 5 discrete datapoints which you can use to generate a trend line. If your calculation needs numbers to map against, just use the column number!
For example, if I have a chart that that shows Page Views for:
You don't need to calculate the value of "Pickle" to map a trend line, just read those values in as (1,55) (2,65) (3,42) (4,99) and calculate the trend line!
Lasse Sørensen commented
This should be no. 1
Adding this functionality would greatly improve our dashboards.
Kathy Walsh commented
Agreed... if this can be done in Excel, Power BI should as well.
This is a must in our organization
Anything you can do in Excel, Power BI should be able to replicate.
Users expect to be able to use that from the Excel.
Trend line for week should be available.
Allan Morris commented
Definitely a requirement for categorical value. Having to resort to Excel for certain visuals with trend lines which I really want to get away from.
Shocked to learn I can't have a trend line for a date hierarchy of Year, Quarter, Month. If I start on Year show the trend line for the years and then show trend line as I drill down to Quarter and Month. Please implement this!