Having issues with a Trend line and the X axis with all month #'s not being displayed

[jonnyA]

Hello,

I have a chart with a trendline, but for some reason my months are only displaying the even #'s (See pic).

Anyone have any advice on how to display all the month #'s, 1 through12?  For example, display the odd #'s too.

[JardaPernicka]

Hi,

instead of numbers you could show month names. 

Create a new column (I assume 'Date' table)  with this DAX:

MonthName = FORMAT(DATE(1, 'Date'[Month number], 1), "MMM")

Use this column in your chart and see if this helps with label visibity issue.
Jarda 
PS: I voted for  idea quoted by  @TheoC this is often requested.

[jonnyA]

@v-henryk-mstf 

I'm sorry, just realized the new formula's should be used as a filter.  But how should the filter be used?

[v-henryk-mstf]

Hi @jonnyA ,

According to the internal logic of the powerbi desktop, trendlines can only be applied on the CONTINUOUS x-axis. But I suggest you can create two measures, one for odd months and another for even months, and put them in the filter. The reference is as follows:

M_ = IF(MOD(MAX('Table (2)'[Month]),2)=1,1,0)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[jonnyA]

@v-henryk-mstf you said create 2 measures, but im only seeing 1 measure you offered.

M_ = IF(MOD(MAX('Table (2)'[Month]),2)=1,1,0)

Is there another one i need?

[v-henryk-mstf]

Hi @jonnyA ,

If it is an odd month, create the first formula; if it is an even month, create the second formula.

M_1 = IF(MOD(MAX('Table (2)'[Month]),2)=1,1,0)

M_2 = IF(MOD(MAX('Table (2)'[Month]),2)=0,1,0)

Best Regards,
Henry

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

[jonnyA]

@v-henryk-mstf 

I cant put those formula's in my x axis?  Do you know why?

[jonnyA]

@TheoC , no problem!  Thank you for trying!

[TheoC]

Hi @jonnyA 

Can you change the "Continuous" to "Categorical" in the options on your visual (i.e. in your screenshot).

This will fix the issue.

Thanks,

Theo 🙂

[jonnyA]

@TheoC , When changing to "Categorical" the trend line disappears and I dont see any way to add it back.

No option to add trend line when changing to Categorical.

[TheoC]

Hi @jonnyA 

I don't believe it's possible.  It has been added as an idea but I don't believe it has yet been accepted. 

You can vote here: https://ideas.powerbi.com/ideas/idea/?ideaid=7c6f5e01-e034-45ca-b638-7d14d6816435

Sorry for the unfavourable outcome... for now.

Theo