Forum Discussion

tyeriksen's avatar
tyeriksen
Frequent Visitor
5 years ago

Visualisation Top N filter needs value 27 to result 5.

Hi all, I have a visualisation of 200+ athletes, where I want to show top N = 5.    First, the qualifying criteria: AB>150 Seasons>2   All good so far:       When I filter Name by top...
General Comment
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi tyeriksen 

The filters in you 2nd image aren't the same as the 1st one.  There's no 'qualifying criteria' filters? Filter AVG by Top 5 rather than Name?

Please supply your PBIX.

regards

Phil

tyeriksen's avatar
tyeriksen
Frequent Visitor
5 years ago

Hi Anonymous , filters were the same, just in the scroll bar above. 


Not a problem to share my file, its public info. The problem can be observed on
Page 'Leaderboard Pitchers' in all ratio tables (e.g. K/IP, ERA, WH/IP, H/IP, BB/IP, OAVG, etc)

Page 'Leaderboard Batters' in all ratio tables (e.g. Slugging Pct. , Batting Avg.)

 

Also having issues with the same type of problem of top N filtering on the page 'Regular Season Batting Records', where Im unable to get a top 5 by Name, regardless of any filter allocation I try (year, league, name, statistic category, etc...)


https://1drv.ms/u/s!Alr9NCLvEz89vlnZ92vqADFIgQmX?e=9xTsSL

Thanks!