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...
In general, all the cells including both filtered values and unfiltered values will be ranked by the Rank function.
In the formula, A2 are the first cell you want to rank, A2:A8 is the range you want to rank.
Then when you filter data, the visible values will be automatically reranked.