Forum Discussion
One Extended line With Data and Forecast
I have the linear regression calculation, I have two tables, one where the data is and the other for the slicer per year to get the salary prediction according to the years of experience, the calculation is fine, what I want is that every time I choose the slicer how can I do so that the salary and the projected salary that I have in the formula as in the image appear on the same line.
Here link of the file Thanks so much https://drive.google.com/drive/folders/1UkukzGBJvpkswJOvWV7apu5DhqPCWZSP?usp=sharing
I need this one line the salary and the predicted salary in one line.
2 Replies
This is surprisingly hard to do (combining values from different fact domains into one scatter plot) but also rather pointless - Your linear regression line already indicates that value. You may need to look into using custom visuals for that.
I know that it is in calculation but I want to graph that calculation as a limit on the line, and change every time i choose a year in slicer, and in this case it is a powerbi report, a custom graph is not necessary
