Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CourtneyLeah
Frequent Visitor

Add trendline to clustered column visual

Hi,

 

I have a cluster column chart that holds our performance score for each month. From what I've read online I should be able to add a trendline to this visual. However, this does not seem to be the case for me.

 

 

 

Can anybody tell me why, or know of any other way to get a linear trend line (and associated equation if possible) on my bar chart.

Cheers

 

1-03-2017 2-08-17 PM.png

1 ACCEPTED SOLUTION

Hi @CourtneyLeah,



The x axis is month year (based off a date column), the y axis is the count of non-compliances. Hope this helps

The x-axis must be a numeric value for trend lines to work currently. The month year column seems in a data type of Text.Smiley Happy

 

If you're using drill down features, the trend line will only work at the top level if the top level is a numeric value, and if any level below that is not a numeric value it will stop working for that level and all below it.

 

In addition, please also make sure that the X-Axis Type under Format tab has been set to Continuous and not Categorical.

 

Regards

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Thanks!  I was having the hardest time finding this simple solution!

Anonymous
Not applicable

And why does Trendline not work in a categorical numeric X Axis?? 

It seems strange that only works in continuous type.

 

Thanks for your help

alaeddin14
Helper I
Helper I

Hi .. 

can you add more details about the axis variables 

The x axis is month year (based off a date column), the y axis is the count of non-compliances. Hope this helps

Hi @CourtneyLeah,



The x axis is month year (based off a date column), the y axis is the count of non-compliances. Hope this helps

The x-axis must be a numeric value for trend lines to work currently. The month year column seems in a data type of Text.Smiley Happy

 

If you're using drill down features, the trend line will only work at the top level if the top level is a numeric value, and if any level below that is not a numeric value it will stop working for that level and all below it.

 

In addition, please also make sure that the X-Axis Type under Format tab has been set to Continuous and not Categorical.

 

Regards

If the x axis is formatted as date/datetime then you should be able to add a trendline. It seems strange if the option is not available for date x axis. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors