Miguel Myers on 08 Oct 2024 05:00:00
To fix inconsistencies in analytic settings, functionality needs to be enhanced to ensure they are on par with other visual component enhancements made for Cartesians, and additional settings for scatter charts is also necessary. Report creators will find it easier to format and customize settings to align with the overall look and feel of their reports.
- Comments (49)
- Merged Idea (1)
RE: Epic idea: Extended analytic functionalities
Trendline in categorical value in x-axis please.
thing is we have to use categorical to have Year-month sorting correctly!
RE: Epic idea: Extended analytic functionalities
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).
Thanks!
RE: Epic idea: Extended analytic functionalities
This will help our organization so much!
RE: Epic idea: Extended analytic functionalities
This would greatly enhance the reporting capabilities at our agency!
RE: Epic idea: Extended analytic functionalities
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.
RE: Epic idea: Extended analytic functionalities
This is extremely important for our organization
RE: Epic idea: Extended analytic functionalities
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)
OR
2) Activate Trendline for Categorical, but caveat to user that Power BI will infer equal increment across category values.
RE: Epic idea: Extended analytic functionalities
how is this not a thing?
RE: Epic idea: Extended analytic functionalities
so much needed...
RE: Epic idea: Extended analytic functionalities
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.