Top 20

[Syndicate_Admin]

Good I have a matrix where countries, customers and purchases appear. I would like to see the top 20 by country of the customers with the most purchases, but when I try I get only the top 20 overall.

Thank you

[Anonymous · Accepted solution]

Hi @bcastrom ,

You could set up TOP N filter for your visual.

Here's a blog for reference.

Power BI - Top N filters | Top N visual-level filters - Power BI Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

could you pls provide the sample data and expected output?

[Syndicate_Admin]

What I occupy is that he shows me something like this, I already added a RankX but he shows me all the data not by country:
1 Argentina Client 1
2 Argentina Client 2
3 Argentina Client 3
1 Chile Client 1

2 Chile Client 2

3 Chile Client 3

1 Brazil Customer 1
2 Brazil Customer 2

3 Brazil Customer 1