Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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
Hi @amitchandak ,
Many thanks for your quick response!
Can you please guide me how to implement them in file i attached?
Thanks in advnace!
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |