cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
j_w Member
Member

Trend line is not available when field type is text or x-axis type is not continuous?

Trend line is not available when field type is text or x-axis type is not continuous.

 

For Years, trend line works:

trend line 01.png

trend line 02.pngtrend line 03.png

 

But for quarters and months don't work:

trend line 04.pngtrend line 05.png

 

What is the solution for quarters and months?

4 REPLIES 4
Anonymous
Not applicable

Re: Trend line is not available when field type is text or x-axis type is not continuous?

Hi @j_w

 

Have you tried using the date hierarchy?

Date Hierarchy.png

 

 

 

j_w Member
Member

Re: Trend line is not available when field type is text or x-axis type is not continuous?

Hi @Anonymous

 

Thanks, tried Quarter and Month from a date hierarchy, but still not working.

 

And the in the report, the financial year (starts from April) first quarter includes Apr, May and Jun, which is not equal to the quarter in date hierarchy.

 

 

Anonymous
Not applicable

Re: Trend line is not available when field type is text or x-axis type is not continuous?

Hi @j_w

 

You can convert month to date and it should work, it works for me. 

 

For quarter, you could change the format a little. Try Qtr2 = right(Table1[Qtr],4)&left(Table1[Qtr],5). Now the sorting would work (See screenshot below).

Date sorting.png

 

j_w Member
Member

Re: Trend line is not available when field type is text or x-axis type is not continuous?

Hi @Anonymous

 

Thanks for your ideas.

 

I guess you might misunderstood my question, I want to enable "adding trend line" for quarters and month but not sorting.

 

 

I tried your ideas, "adding trend line" is still not available:

 

trend line 06.pngX-Axis has no Type optiontrend line 07.pngAnalytics has no Trend Line option

 

Thanks.

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 773 guests
Please welcome our newest community members: