Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I'm using a TOPN filter on a visual, and it is showing more than the number prescribed. This is because they all have an identical value. This visual is meant to be a snapshot of the current state of this part of the business, so the extra lines are not required. Is there a way to "hard limit" it to TOPN, just choosing the necessary number for the visual?
Thanks
Solved! Go to Solution.
Hi @Anonymous,
Maybe it is not supported to sort duplicate values using TOP N, you can add index column to get your expected output.
Best Regards,
Link
I like your solution, except I'm working with measures. Your solution definitely has a place with other applications and I will try to remember it. Thanks for your reply!
add a very small random number to your values.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.