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.

     

     

     

     

     

     

showy123's avatar
showy123
Frequent Visitor
9 months ago

Hi Thanks for your reply,

what is the best way to share the ..pbix? I tried to drag and drop it inside here but .pbix is not supported.