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.
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 trend line fits to only the filtered data points. Is there a way to keep the trend line constant and then HIGHLIGHT certain schools selected from the slicer?
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.
Sure - you'll just have to ignore the filter using ALL in the calculation of the trend line.
The sytax will be something like:
Trend Line Value All := CALCULATE([Trend Line Measure], ALL('Schools'))
Obviously you may need to tweak the formula so that it matches your expectations.
Thank. I am not seeing an option to add a formula under the analytics tab for the scatterplot option . . .where could I add this formula to impose the line on the scatterplot . . . .
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |