Forum Discussion
TOP N Displays more values than set
I have a Top N filter on a visual in Power BI Desktop on the out of the box 'Title' field from the Risks list in Project Online. I want to limit the risks to show only the Top 3 based on the Exposure field. One of the projects is bringing in more than 3 items. I have 3 risks with an exposure of 16 (that would could as first item to display), one risk with an exposure of 9 (would count as second item to display) and three risks with an exposure value of 6 (would count as third). I would expect to see these 7 items in my visual. However I am also seeing 3 items with an exposure value of 4. I cannot figure our why I'm seeing these additional 3 risks as they would count as a 4th item. How can I limit it to only the Top 3?
The filter type is Top N
Show items is set to Top and 3
By Value is set to Sum of Exposure
Thanks in advance. NCP
3 Replies
- amitchandak
Super User
Anonymous , are some values repeating?
if yes, check how to break ties : https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
Check my TOP Video if that can help
https://www.youtube.com/watch?v=QIVEFp-QiOk
- AnonymousNot applicable
Hi No values are not repeating. I'll have a look at the link you've sent and the video as well.
- AnonymousNot applicable
Anonymous
Can you show screenshorts or something can visually explain your situation?Paul Zheng _ Community Support Team