user defined groups in power bi

[Anonymous]

hi, I have a column of amount and customer name. I want to group the amount values into 5  groups where the upper limit and lower limit values for each group will be entered by the user via slicer. please help me out.. didn't know how to write logic. 

[v-yiruan-msft]

Hi @Anonymous ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.
Best Regards

[amitchandak]

@Anonymous , You can try percentile bins, refer

https://community.powerbi.com/t5/Desktop/Percentile-Bins-Group-by-Year/td-p/45621

https://community.powerbi.com/t5/Desktop/Calculate-percentile-by-group/td-p/478239

[Anonymous]

I guess to didn't understand my problem. I have a column called amount which has lots of whole no. value and want to divide the values into 5 groups where the starting value and the ending value of each group should be entered by the user in the report. basically, the size of each group is decided by the user and the no. of column values falls in groups according to the size of the group..

[v-yiruan-msft]

Hi @Anonymous,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. If no, please share some sample data (exclude sensitive data) in your data model and your expected result with examples. Thank you.

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.