Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
Is there a way to use multiple TOPN Filters in a single visualization?
Hi, @dilshan_17
Please correct me if I wrongly understood your question.
If you want TOPN by multiple columns, I think in general, it can be done.
If it is OK with you, please share your sample pbix file, then I can try to have a look into it to come up with a desirable solution.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@dilshan_17 , can you share an example ?
refer: https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
Hi Amit,
I've attached a screenshot of a requirement Sample.
Hi @dilshan_17
Can you share some dummy data to show the data structure? I guess category 1 is parent level of category 2 and category 3, but what is the relationship between category 2 and category 3? We need more info about original data to look for the appropriate solution.
Thank you.
Community Support Team _ Jing
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |