Power BI

Needs Votes

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

Vote (385)

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)

Comments (48)

Jesse Brooks on 14 Dec 2020 18:49:18

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

This functionality would be hugely useful. I'm surprised it's not an option already. It seems silly that you can't show all your X Axis data points AND have a trend line. In what world do you not care about your X Axis data points?

Thank you,
Jesse

Andrea York on 17 Jul 2020 15:57:17

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

This is a feature that our Users are all asking for, as the missing labels are causing issues with understanding the data for a simple bar chart.

Shyamal Dutta on 10 Jul 2020 17:22:37

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

Need is badly! Please make this available.

Fabio on 06 Jul 2020 00:11:50

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

yes, please! We need

Caleb Mann on 06 Jul 2020 00:11:34

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

Add it please! Much needed!

Lee on 06 Jul 2020 00:11:23

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

I would be happy with the ability to sort the x axis for continuous line charts but this is even better. This is a must have feature!

Andrew Lean on 06 Jul 2020 00:09:31

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

I can understand the difficulty of showing trends over all categories.
But trends over date hierarchies should work fine.
It feels like a bug that it can't.

Doug Matheson on 06 Jul 2020 00:09:28

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

This is the #1 thing missing from Power Bi. Its a bit embarrassing when discussing with an auditor that you have a great charting program that dynamically reaches across rolling 6 month and 12 month data.....and then have to show them a different chart that you made in excel in order to satisfy their requirement to show a positive trend in that data.

Power BI User on 06 Jul 2020 00:07:12

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

Trendline in categorical value in x-axis please

Joko on 06 Jul 2020 00:05:11

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

Trendline in categorical value in x-axis please.
thing is we have to use categorical to have Year-month sorting correctly!