Forum Discussion

showy123's avatar
showy123
Frequent Visitor
9 months ago
Solved

Build dynamic TopN Filter on page with fieldparameter

Hi everyone, I am trying to build a dynamic TopN filter with field parameters. I cannot use field parameters in the filter bar under TopN filtering, so I would like to put it on the page and use...
Need Help
Show and Tell
Tips and Tricks
  • kushanNa's avatar
    kushanNa
    9 months ago

    Hi showy123 

     

    There must be different ways to solve this, but here is my solution:

    1. Create a numeric parameter (TopN).

    2. Create two measures (TopN Filter Chart1 and TopN Filter Chart2) — one for each chart — that return 1 if the column falls into topN. Use these measures as visual-level filters to show only 1.

    I have attached a sample file with the measures I created for your reference.

     

     

     

     

     

     

kushanNa's avatar
kushanNa
Super User
9 months ago

Hi showy123 

 

There must be different ways to solve this, but here is my solution:

  1. Create a numeric parameter (TopN).

  2. Create two measures (TopN Filter Chart1 and TopN Filter Chart2) — one for each chart — that return 1 if the column falls into topN. Use these measures as visual-level filters to show only 1.

I have attached a sample file with the measures I created for your reference.

 

 

 

 

 

 

  • showy123's avatar
    showy123
    Frequent Visitor
    9 months ago

    Hi
    works perfect, thank you a lot