Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a simple linechart with MonthName on the x-axis (this is derived from my own custom built calendar going from Apr to Mar as per Financial Year) and a DISTINCTCOUNT Measure of IDs for the Y axis, I would like to add a Trendline.
I do not see the option at all when using the Line Chart or Clustered Column chart:
Can anyone help? Thjis should be easy to do, its very frustrating!
Thanks
Solved! Go to Solution.
Yes,
It looks like you're using a measure at the Intercept + Slope * measure in the RETURN section. You want to use your column [Progress_date] not a measure.
ok , but may I ask why there is the red line under my [Slope1] and [intercept]? thanks..
When you use LINEST or LINESTX it creates a single row with ten columns. In the measure that I provided we are creating a variable using LINESTX. The red lines under [Slope1] and [Intercept] is becasue it doesn't recognize those as columns until you've finished creating the measure. Those variables get calculated in order from top to bottom.
with same Y Axis set at Zero:
Thanks, I've finally got it to work 😊
I've notice the trendline is far steeper with your Variable (see solid line in top line graph) compared to when I use the inbuilt Trendline using the Continuous x Axis date range. This inbuilt range has every other month missing which is why I'm desperate for an alternative option.
I guess I need to decide which one to use. My only other option is to Snip an image of the the x axis with complete months and paste them over in Powerpoint when this get presented, incredible we still have to do this in 2023!
Thanks for all of your help!
as per screenshot, one is far steeper than the other. Its fine though, I can use either
Thanks for helping me with this, much appreciated!
@ArchStanton , Click on the first icon.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |