Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @jonny7072 ,
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.
Hi @jonny7072 ,
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.
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?
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |