Forum Discussion
Dynamic Filter using TopN or Rank/RankX
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.
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.
2 Replies
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.You can get it from topN filter on filter pane
