How can we improve Power BI?

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.

174 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

27 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Cindy Duran commented  ·   ·  Flag as inappropriate

    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.

  • Jeff commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Agree - you have NO idea what cosmic workaround calculations me and my colleague made to get this thing working...

  • Justin Shands commented  ·   ·  Flag as inappropriate

    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:
    "March"(55)
    "April"(65)
    "Cucumber"(42)
    "Pickle"(99)

    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!

  • Allan Morris commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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!

  • Benjamin Swift commented  ·   ·  Flag as inappropriate

    Agree that this is required functionality: It doesn't make sense for the trend line to only be available with a Continuous X-Axis.

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.