Reply
avatar user
Anonymous
Not applicable

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?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

3 REPLIES 3
avatar user
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?

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

 

lbendlin_0-1717695003192.png

 

lbendlin
Super User
Super User

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)