Forum Discussion
Show Top N without filtering data
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
