Forum Discussion
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...
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.