topic Re: Month names and trendlines in Custom Visuals Development Discussion

Month names and trendlines

Anonymous — Wed, 05 Jun 2024 21:18:04 GMT

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?

Re: Month names and trendlines

lbendlin — Thu, 06 Jun 2024 00:53:01 GMT

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

Re: Month names and trendlines

Anonymous — Thu, 06 Jun 2024 16:27:55 GMT

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

Re: Month names and trendlines

lbendlin — Thu, 06 Jun 2024 17:30:09 GMT

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