Forum Discussion

aashton's avatar
aashton
Icon for Helper V rankHelper V
2 years ago
Solved

Adding Linear Trend line to bar chart

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?

 

Need Help
  • ToddChitt's avatar
    ToddChitt
    2 years ago

    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.

3 Replies

  • ToddChitt's avatar
    ToddChitt
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      aashton
      Icon for Helper V rankHelper V
      2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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