Show Top N without filtering data

Hi Anonymous ,

I think you use Min line, Max line,Average line, Median line in Analytics. They are dynamic based on data in your visual. If you filter your data by Top N function, they will change. Here I suggest you to create measures to calculate the value you need with All function and then use Y-Axis Constant Line in Analytics.

Here is my test.

They are dynamic when I use Top N.

Create measures as below.

Avg = AVERAGEX(ALL(Sheet20),Sheet20[Value])

Max = MAXX(ALL(Sheet20),Sheet20[Value])

...

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.