Dynamic Filter using TopN or Rank/RankX

[Anonymous]

Hi, I created a TopN filter and an Rank on a field in a table. I also created a filter with a slider.

My qustion is how could I use that slider as a filter, so that if a user wants to 5 records, the slide it to 5, or 6, 7, etc.

I have a default setting of showing 5 records but would love to give a user the ability to choose as many as they'd like. 

thank you.

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Step 1: Create a ranking measure

_Rank = 
RANKX(ALLEXCEPT(financials,'financials'[Country],financials[Product]),CALCULATE(SUM(financials[Profit])),,DESC,Dense)

Step 2: Create a What If parameter (GENERATESERIES(1, 100, 1))

Step 3: Create a measure that controls whether records are displayed

_Show = 
IF([_Rank]<='_Selected Records'[_Selected Records Value],1,0)

Step 4: In the filter pane, filter for items where the measure of Step 3 is equal to 1

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

You can get it from topN filter on filter pane