Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Month names and trendlines

 

On the clustered column chart.   I need to do a monthly date average for the past six months that includes a trendline for our service ratings.  I am able to get the visual to look okay when I use X-axis month (for month number) and Y-axis average service rating.   

 

However, the ask is for month names to be visible on the X-axis rather then the number and to include the trendline.   It appears the visual doesn't support this as when I use the name to option for the trendline disappears.    

 

What are some ideas on how to go about fulfilling this ask?

  • Put your date column on the trend line but then format it as "mmmm".

3 Replies

  • Put your date column on the trend line but then format it as "mmmm".

  • Anonymous's avatar
    Anonymous
    Not applicable

    To modify the format I need to use data that is imported.  Is there a solution that would work with direct query?

    • lbendlin's avatar
      lbendlin
      Super User

      Cannot reproduce.  Works for me in Direct Query mode as well