Show Top N without filtering data

[Anonymous]

I would like to only visually show the top N results of this visual:

to look more like this: 

I can't use the top N filter because the dotted lines are dynamic and will change when the top N filter is used. 

Is there a way to show a few legend values without filtering the data?

[Anonymous · Accepted solution]

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.

[lbendlin]

What is your definition of "top N" for this scenario?  A max value, largest average, something else?  Is that something that needs to be calculated via a measure or can it be done via calculated column?