Forum Discussion
Top N - Simply do not understand it.
Hi
I can't for the life of me work out what simple method to get a Top 5.
I have a column that collects Hazard types in a sharepoint list. I would like to use a Multi-Row card to display the Hazard types and Totals which is the easy bit. However I would like just to show the Top 5 only to save space on the report.
If I put the column in the value by no matter the result it isn't correct or shows too many.
What do I do without the need of an engieering degree just short of rocket science to get the top 5?
You are getting 7 for Top 5 because of the duplicate values. 2 is the fifth result and there are 3 rows with that value
8 Replies
PaulDBrownCommunity Champion
You are getting 7 for Top 5 because of the duplicate values. 2 is the fifth result and there are 3 rows with that value
That makes complete sense. Thanks Paul.
- PaulDBrown
The simplest way is to use the TopN option in the filter pane, "Sum of Sales" being a measure:
That doesn't work, "If I put the column in the value by no matter the result it isn't correct or shows too many."
It's just one column of data I want the top 5 from. If I put in count of hazard type and put 5 for the Top N number I get more than 5 results etc
- PaulDBrown
Are you using a measure? Can you provide a sample PBIX file?
