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.
Hi all,
I have a graph where I have included the trend line from the analytics pane. Is it possible to see its value? With tooltip better.
Thanks!
Definitely not a simple option like a tooltip, but @Greg_Deckler wrote a blog article about forecasting, correlation and seasonality in Power BI some time ago. He provides a process to calculate slope and intercept (for a linear regression), but this is likely the same value that the trend line calculates (I'm unsure how the built in trend line caclulates slope, as in does it use Least Squares to fit the line or something simple like (Y2 - Y1)/(X2 - X1)).
Perhaps it will provide you what you need:
You would take the values (slope and intercept) and concantenate them into a string that you could put on a card/text visual.
In the first reply to this post I included this link and said
Look at the links here
http://community.powerbi.com/t5/Desktop/Generate-Forecast-Value-in-a-Table/m-p/107843#M45288
This link takes you to @Anonymous's response which includes another 4 links and 1 of them is the blog article!
@dkay84_PowerBI wrote:Definitely not a simple option..............
...................or something simple like (Y2 - Y1)/(X2 - X1)).
@Sean that's too many nested layers, like Inception. I didn't follow your first link to begin with
@psikonetikYes basically all other lines let you display the Value except the Trendline
Therefore if you want a Tooltip you'll have to write the Measure that duplicates the built-in calculation
If I recall @kcantor was asking about this forecasting feature - what formula/model they use to come up with the trendline?
(in a post which I can't seem to find now)
Look at all the links here
http://community.powerbi.com/t5/Desktop/Generate-Forecast-Value-in-a-Table/m-p/107843#M45288
The only information I ever found was that the forcasting was based upon Exponential Smoothing. Information on this particular feature seems a little hard to find.
Proud to be a Super User!
mmm interesting so seems there is a hole here right?
Should be really easy to implement it as a feature
I would like to know more about this feature as well. Just having a line doesn't really answer any questions.
Proud to be a Super User!
@psikonetikand @kcantor Okay here's my 2 cents worth
I believe this done for legal reasons (I hope I'm wrong and this becomes available though)
This is kind of predictive/forecasting feature potentially opens up the provider to legal liability (especially one with deep pockets)
Similar predictive real-time stock price ranges are available (although the model there is different and based on STD DEV)
However each time you turn it on you have to read a disclaimer and click to agree that this is not a guarantee blah blah etc.....
Again this is purely a speculation though!
Maybe they are waiting on their Legal to draft a disclaimer pop up message
Once again I believe you are correct. I would, however, suggest that they have the disclaimer ready to go as soon as the web team figures out how to fit it into a single pop up window without using chapter numbers and a font size of 0.0002.
Proud to be a Super User!
Isn't that the truth?
"Forward-looking statements are subject to risks and uncertainties described in our..."
Their Investor Relations page appropriately uses PBI to show their financials
https://www.microsoft.com/en-us/Investor/earnings/trended/yearly-income-statements.aspx
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |