TOPN FUNCTION

[dilshan_17]

Hi,

Is there a way to use multiple TOPN Filters in a single visualization?

[Jihwan_Kim]

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.

[amitchandak]

@dilshan_17 , can you share an example ?

refer: https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

[dilshan_17]

Hi Amit,

I've attached a screenshot of a requirement Sample.

[v-jingzhang]

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