Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

user defined groups in power bi

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. 

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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..

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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