cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CourtneyLeah Frequent Visitor
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

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Add trendline to clustered column visual

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
alaeddin14 Regular Visitor
Regular Visitor

Re: Add trendline to clustered column visual

Hi .. 

can you add more details about the axis variables 

CourtneyLeah Frequent Visitor
Frequent Visitor

Re: Add trendline to clustered column visual

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

alaeddin14 Regular Visitor
Regular Visitor

Re: Add trendline to clustered column visual

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. 

v-ljerr-msft Super Contributor
Super Contributor

Re: Add trendline to clustered column visual

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

PabloMaldonado Regular Visitor
Regular Visitor

Re: Add trendline to clustered column visual

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

Choctawgirl77 Frequent Visitor
Frequent Visitor

Re: Add trendline to clustered column visual

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 218 members 2,380 guests
Please welcome our newest community members: