Cant add trendline when Month-Year axis is text . Please help

[laurent_rio]

Hi,

I have this chart where i get the Month-Year from my calendar table 

Month-Year = 'Date Table'[Month Name] & "-" & 'Date Table'[Year]

When i create chart like this 

I cant only get the trendline option if i change my axis x into numeric of Month Year 

 

YearMonth = 'Date Table'[Year]*100 + 'Date Table'[Month]

Any trip where i can still have Month Name and Year but also have trendline ? I tried using date Hierarchy is not work. Its only show year

Really Appreciated

[StefanoGrimaldi]

how are you generating the month name format? creating it as text or as a date format: 

basically the correct form for this type of options to work will be manking them something like this: MonthName = FORMAT(DATE(1, [Month], 1), "MMM") so the model understand thats a date related field instead of a text value. 

check this: https://www.spguides.com/get-month-name-from-month-number-in-power-bi/#:~:text=Go%20to%20the%20Model....