Forum Discussion
Report Page Tooltip displaying the wrong value
Hi kirbynguyen ,
Is Residual a measure or a calculated column? Please try to create a measure Residual as below and check if you can get the correct result...
Measure = SUM([Y Value]) - [Predicted Value]
If the above one is not your expected result, please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Everything is a measure. The residual needs to be a measure because the time frame may change and that changes the slope of the line. What's weird to me is that the X value shows the correct value, but the residual does not
Anonymous
After some more testing, I found that the Predicted Value always calculates as the Y value when used in the tooltip and I'm assuming that it isn't taking into account the prediction value as a whole.
For ex:
looking at the data in the table, if you were to filter it to just one day, the predicted value will be exactly the same as the Y Value and thus, the residual would be 0. (for 10/3/2022, the Y Value is 83.63 and the Predicted Value is 87.13, but if filtered to one point, the Predicted Value changes to the Y Value 83.63, so the new [Y - Predicted Value] is 0 instead of -3.5)
So I found out why this was happening, but still do not know how to resolve this issue. Any help would be appreciated.
