Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
Proud to be a Super User! | |
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
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.
Proud to be a Super User! | |
@ToddChitt Yes, you are correct, that second chart was just an example. Thank you for the explanation, I'll try to work that out.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |