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

Highlighted
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
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 137 members 1,594 guests
Please welcome our newest community members: