Skip to main content
Microsoft Idea

Power BI

Needs Votes

Ability to use Trend Line with Categorical Values in X-axis

Vote (385) Share
's profile image

on 26 Sep 2016 21:17:59

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.

Comments (48)
's profile image Profile Picture

Benjamin Swift on 05 Jul 2020 23:07:23

RE: Ability to use Trend Line with Categorical Values in X-axis

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

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:03:29

RE: Ability to use Trend Line with Categorical Values in X-axis

Must one

's profile image Profile Picture

Roberto Lammoglia on 05 Jul 2020 22:59:56

RE: Ability to use Trend Line with Categorical Values in X-axis

It's a must !!! Absolutely indispensable thing

's profile image Profile Picture

Earlene Schanze on 05 Jul 2020 22:54:52

RE: Ability to use Trend Line with Categorical Values in X-axis

MS Power BI needs to include the same trend line functionality offered in MS Excel.

's profile image Profile Picture

Mohammad Mubarah on 05 Jul 2020 22:54:47

RE: Ability to use Trend Line with Categorical Values in X-axis

Please try to Provide trend-line with function in the next update

's profile image Profile Picture

Power BI User on 05 Jul 2020 22:54:40

RE: Ability to use Trend Line with Categorical Values in X-axis

must have, PowerBI will never catch on when the actual visualizations are still stuck in shareware mode

's profile image Profile Picture

Jurgen VD on 05 Jul 2020 22:54:08

RE: Ability to use Trend Line with Categorical Values in X-axis

this is really a must have, because at the moment i don't see the data that i want on the X-Axis if i have a continious graph with trendline.

's profile image Profile Picture

Stephen on 05 Jul 2020 22:48:54

RE: Ability to use Trend Line with Categorical Values in X-axis

This would actually be useful - as long as it's used correctly.
eg. Your x-axis is a categorical day-of-the-month and y-axis is number of jobs performed, a trend line might show that over time you tend to be busier towards the end of month.
Now you can adjust your staff roster, or distribute the jobs more evenly, or whatever is best for your business.