Month Only On X Axis and Trend Line

[PaulPalkowski]

I have looked and can't seem to find a sensible answer or solution...My table only has three columns...very simple

My data is from jan 1 2020 to Sept 30 2020. I have a column that has a date (X Axis), and another column that has a value (Value), and another column that represents one of three different types (Legend). 

All I want is a simple Cluster Column chart, that shows

1. the month name, for the x axis
2. The values as the columns
3. The types for Legend

Easy.. done...

Now, All I want a trendline

Not easy for whatever reason, if I remove year from the date heirarchy I cannot select continous type for my X axis...

I don't want to show the year,

Once I put year in my chart, i get this

I want to show each month and what the trend currently is..

Why is this so difficult?

Obviously PowerBi knows it's a date since it is arranged that way, and not alpha...

[v-zhenbw-msft · Accepted solution]

Hi @PaulPalkowski ,

Sorry for that the text type of the X axis will affect the Trend line.

If you want to add a trend line, you need to create a month number column, and put it in X axis.

Month number = MONTH('Table'[Date])

Or you can refer the following links.

https://geekdecoders.blogspot.com/2019/02/how-to-add-trend-line-in-power-bi-chart.html

https://community.powerbi.com/t5/Desktop/Trend-Lines/td-p/31793

If you have any question, please kindly ask here and we will try to resolve it.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulPalkowski]

Microsoft has some work to do for this..

Got what I needed

[PaulPalkowski]

I did get that far, How do I display the Month name?

[v-zhenbw-msft]

Hi @PaulPalkowski ,

Sorry for that if you want to add a trend line, the x axis cannot be text.

You can create a trend line based on month number.

Or you can create Line and clustered column chart, and create a line using DAX.

The more detail please refer the following post.

https://community.powerbi.com/t5/Desktop/DAX-to-create-a-Trend-line/td-p/398438

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PaulPalkowski , with year, you use expand icon the one with reverse square Y. That might give a better UI and continous axis. 

[PaulPalkowski]

No, when I expand the trend line option disappears

Not Expanded

Expanded

[amitchandak]

@PaulPalkowski , The option remains in line visual after expand not in bar. I tried to concatenate label: off it looks better but not continous