topic Show Top N without filtering data in Developer

Show Top N without filtering data

Anonymous — Tue, 04 Jan 2022 22:37:18 GMT

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?

Re: Show Top N without filtering data

lbendlin — Wed, 05 Jan 2022 23:26:52 GMT

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?

Re: Show Top N without filtering data

Anonymous — Wed, 12 Jan 2022 06:40:27 GMT

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.