Forum Discussion
Top 20
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
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.
3 Replies
could you pls provide the sample data and expected output?
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 12 Chile Client 2
3 Chile Client 3
1 Brazil Customer 1
2 Brazil Customer 23 Brazil Customer 1
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.
