Forum Discussion
Top N Filter doesn't work (with examples)
Anonymous
Thanks for the file.
A couple of questions:
1) So when you want to flter by TopN managers, which field determines "Manager"? Is it "Shop"?
2) When you wish to filter by the TopN, is the TopN for the whole dataset (so when you show the results by for example "Asset Class", the TopN refers to the overall performance and not the TopN within "Asset Class") , or is each visual to represent the TopN for the category shown in the visual? - see my example in my previous post.
The top N refers to the managers with the most assets under management. That is to say:
-If I filter by Top 5 I want the entire page to be filtered with the data of the 5 managers with the most assets under management, I do not want data from other managers to appear that are not that top 5
-If I filter by Top 10 I want the entire page to be filtered with the data of the 10 managers with the most assets under management, I do not want data to appear from other managers that are not that top 10
In the case of the graph: AuM by Asset Class I want the filter on selector 5 or 10 or 30 .. that graph shows the AuM of those selected managers filtered by Asset Class.
In summary, I want both the top 3 letters on the right, as well as the table, and the different graphs ONLY to show me the data of the Top N filter managers that I have selected. And that data is the relationship between the AuM column and different columns with other categories
I have created a proxy eliminating the real data and eliminating columns to be able to share the powerBI and the equivalences are the following:
Shops = Managers
Seller = Fund
Sales = Aum
Thank you very much for the great help