Forum Discussion
Maureen
Helper III
Helper IIIKeep a constant trend line when filtering
In this attached scatterplot, I have schools for the entire state with a trend line. I would like to filter to certain schools to see where they are in relation to that trend line but when I do, the...
The analytics lines, such as trend, are baked into PowerBI and as such you cannot build measures in there.
The formula that Jirka suggested would replace the value that you used in the visual, and is a measure that you build such as SUM ( SALES[sales] ). The idea is that ALL would remove the filters present in the visual and so the trend line would move with the schools that you choose. If you replicate the measure with your own values and introduce that into the visual then you should get what you need.