Adding a field parameter fields to TopN visual filter pane

[sivarajan21]

Hi,

I have created a field parameter table as below:

I have used above field parameter in below visual x-axis:

Now its working well! But I want to filter this visual for TopN values as shown below based on parameter table fields column as shown below:

But when i drag this field parameter column in filter this visual pane 'By value' it shows First Parameter and it doesn't aggregate.

I am confused how to filter visual by the top 20 'Name' column by variance Field parameter fields column.

Can you please help us with this?

PFA file here Portfolio Performance - v2.12 - Copy.pbix

Thanks in advance!

@Ahmedx @amitchandak @marcorusso 

[amitchandak]

@sivarajan21 , I think it is better to use TOPN measure in the field parameter created for measures

if you want switch base on axis

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

Get Super Dynamic TOPN using Window, Numeric, and Field parameters along with calculation groups- https://youtu.be/YW1SOk9V9xk

Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

[sivarajan21]

Hi @amitchandak ,

Many thanks for your quick response!

Can you please guide me how to implement them in file i attached?

Thanks in advnace!

@amitchandak @Greg_Deckler @marcorusso @lbendlin @Ahmedx