Forum Discussion

mbidelski's avatar
mbidelski
Icon for Helper I rankHelper I
6 years ago

Rank filtered values

Hello, Im trying to create a set of charts like this:   The year slicer filters data for the left chart. The right chart uses a copy of years column and measure ignoring the year filter fro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mbidelski  just a little thought, if you use RANKX to rank all the values, you have the rank index numbers so you can use IF to blank out middle values and leave only top 5 and bottom 5.