Dynamically categories all customers into Top and Others based on selection of TopN number

[Anonymous]

Objective:- Dynamically categorize all customers into Top and Others based on the selection of TopN number

Requirement :- Create a parameter allowing users selection of Top N customers

                         Categorize customers with ranking less than or equal to the parameter selection to "Top"

                         Categorize remaining all customers into "Others"

                         Create a graph showing a comparative picture of Net Amount and Number of Unique Customers between Top and Other Customers

Scenario:-

  

Refer to this data

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[Anonymous]

Hi @Anonymous ,

I found these similar posts which might be helpful to solve your issue. Please kindly refer to:

Dynamic TopN + specific company / Dynamic Top N and Others category and own company category

TopN with dynamic context filtering

Showing Top N values per category based on a value

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.

[amitchandak]

@Anonymous , Refer if this blog can help

https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/