- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Put your date column on the trend line but then format it as "mmmm".

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To modify the format I need to use data that is imported. Is there a solution that would work with direct query?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cannot reproduce. Works for me in Direct Query mode as well
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Put your date column on the trend line but then format it as "mmmm".

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-22-2025 03:31 AM | |||
03-14-2023 09:44 AM | |||
07-31-2024 02:45 AM | |||
12-06-2024 06:59 AM | |||
10-22-2024 01:19 AM |