Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tbrownParts
Regular Visitor

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
tbrownParts
Regular Visitor

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".

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors