Forum Discussion
TOPN FUNCTION
Hi,
Is there a way to use multiple TOPN Filters in a single visualization?
4 Replies
- amitchandakSuper User
Anonymous , can you share an example ?
refer: https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
- AnonymousNot applicable
Hi Amit,
I've attached a screenshot of a requirement Sample.- v-jingzhangCommunity Support
Hi Anonymous
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
- Jihwan_KimSuper User
Hi, Anonymous
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.