Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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