How to get trend lines in a date hiearchy?

[VinhTon]

Edit--because trend lines are only offered with continuous x-axis and continuous are only offered with date fields, how do I get a trend line with a date hiearchy? For example how do I show trend line for year month. See the following image where I no longer have the trend line option when I go from Date to Year Month

The trend line option is not showing under the add more analytics option in the Visualization pane.

I'm using dates from a Date table.

I tried following this tutorial https://www.youtube.com/watch?v=u-nEn8aolQ8

In the clustered column chart, there is no option to change from categorical to continuous in the format's x-axis. see image below.

In the line chart, there is the continuous option but it stays as categorical when I click on it. see image further below

[LarsKildemark]

Hi winhTon,

I am expriencing the same problem. I have fond that if Power BI generates the date hierarchy automatically the trendline is available when you go throught the different levels.

However when I create a date table and use that then I am no longer able to get the trendline for anything but years. I don't know how the automatically generated hierarchy defines its levels and the data types in order to keep them all "continuous".

I have tried to have quarter and months be "date" by definingen them as for example end of quarter or end of month, but it does not work.

Here are som examples from an automatic hierarchy when I can see the trend line on all levels of the hierarchy (year, quarter, month):

[parry2k]

@VinhTon what have you tried based on the provided solution.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[parry2k]

@VinhTon check this video on my YT channel and see if it helps. X-Axis Type, Data Type and Visual Scroll Bar - Power BI - YouTube

[parry2k]

@VinhTon Continuous option is only available when you have a number or date column on the x-axis.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[VinhTon]

Thanks this helps identify the problem but I still am not able to get a trend line with a year month format. I tried creating a date hiearchy and updated the post to reflect that. Would you know?

[v-easonf-msft]

Hi， @VinhTon 

If your problem has been solved, please accept a reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[VinhTon]

it has not been solved

[fhill]

....  Thoughts on creating a messure, that is your own math to create your own 'trend line' then add as a secondary 'values'?