Adding Linear Trend line to bar chart

[aashton]

Hello,

I have a bar graph with the Month/Year on the x-axis, and three measures on the y.   The user is asking for a linear trend line of one of the measures.  Not really sure what that means?

This is what the bar graph looks like now, with and without a line for the Total Applications.  

This is the users example of how she wants it to look:  

I'm thinking it's just a nice straight line because those numbers only go up.  In reality, Total Applicatoins go up and down.  Would a linear line look at the first month of 238 and the last month of 75 and just have a straight line pointing in the down direction?  How would I do that?

[v-kongfanf-msft]

Hi @aashton ,

May I ask whether the problem has been solved? If so, please mark it as the correct solution, and point out if the problem persists.

Best Regards,
Adamk Kong

[ToddChitt · Accepted solution]

Am I correct in stating that the user's sample has nothing to do with the two graphs above it? It is only to indicate that she wants a straight line between the first and last points (238 and 75)?

Start out by just entering some hard numbers into a new DAX table: two rows (first month and last month) and their respective values 238 and 75. Join that to the common x Axis date dimension. See what happens when you plot it on top of your columns (Yes, that is a COLUMN CHART, not a BAR CHART. Bar charts go horizontal.)

Now try to recreate that table with a SUMMARIZE DAX statement, with fancy FILTER statements that filter for first and last month only.

Hope that helps.

[aashton]

@ToddChitt  Yes, you are correct, that second chart was just an example.  Thank you for the explanation, I'll try to work that out.