Forum Discussion
Top N Filter doesn't work (with examples)
I have created a new proxy to share in order to someone can help me:
https://app.powerbi.com/reportEmbed?reportId=c6c529fe-ec4f-4265-9ae9-905c09bb6312&autoAuth=true&ctid=dcc1870c-76e0-4f83-b4dd-ab08f30c5799&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVrLXNvdXRoLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9
Community ChampionAnonymous
Can you pease share the PBIX file itself? (through Onedrive, Dropbox, Google Drive..)
- PaulDBrown
Anonymous
See if this works for you (I wasn't sure what calculation you wanted to see in the visual "TopN sobre Income Total"). I've changed the TopN range to 1 - 4 (assuming the rank refers to "Shops") since there are only 4 possible in the sample data.
The data is showing the values for the TopN Shops overall (ie. not ranked for each category in the visuals)
That is exactly what I need, thank you very much, I do not know how to thank your help.
I only have one problem with the data table, since I had to create another measure to order the shops / managers by AuM desc. The calculation of the total of the table does take into account the filtered Top N, but it shows all the Manager / shops of my table and I just want it to show me:
-If I choose 5: the first 5 managers
-If I choose 10: the top ten
So i created a new measure for tank ONLY for the table:
I had to create this new measure because the measure that you have used returns only the number 1 for all shops / managers as seen below:
- PaulDBrown
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 categoriesI 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