Month names and trendlines

[Anonymous]

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?

[Anonymous]

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

[lbendlin]

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

[lbendlin · Accepted solution]

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