Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Line Chart: Trend Line at year but not month level?

I have a year and month hierarchy and when I view a line chart by year I can go to analytics pane and add a trend line.

 

Then when I do the expand all down one level in hierarchy button (the single line that splits into two like a two pronged fork) the trend line goes away and I can't bring it back under analytics.

 

Am I missing something basic here...what is going on?

 

Thanks!

3 REPLIES 3
v-sihou-msft
Microsoft Employee
Microsoft Employee

@OneWithQuestion

 

As I tested, the trend line only appear when the category field on X-axis is numeric.

 

Regards

I may not be following:

 

So then, NOT dates?

 

If I have Years: 2002, 2003, 2004, etc.... 2017

 

then drill down to months: 2017-01-01, 2017-02-01, etc... that won't work for Trends?

Power BI Line Chart with Trend line work only for a date as axis. If you use anything line mm/yyyy or not numeric, this function don't works.

Vithor Silva | http://blog.vssti.com.br

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors