Forum Discussion
Helper VAdding Linear Trend line to bar chart
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.
Super UserAm 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.
