Forum Discussion

CourtneyLeah's avatar
CourtneyLeah
Frequent Visitor
9 years ago
Solved

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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

     

    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

CourtneyLeah's avatar
CourtneyLeah
Frequent Visitor
9 years ago

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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

 

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