cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dakotaperryman
Frequent Visitor

Allow Grouping for Client

Hello Experts, 

 

This may be a simple yes no question for the forum, but I am interested to understand if Micosoft gives users the ability to create a data grouping from PBI Service. The request from business is to allow them to create custom groups in the front end and then reflect their group in the data. There are an arbitrary number of groups, and it's impossible to determine all of the number of groups that the clients would want to create. At this point in our development, literally any solution will suffice. Thank you all!

 

To better visualize this request, please view this example:

Data Before Group:

 

SpecialtyDollars

Hospital

100
NP200
PA300
Outpatient400

 

Data After Group:

SpecialtyDollars

Hospital

100
NP/PA Group500
Outpatient400
1 ACCEPTED SOLUTION
nickyvv
Super User
Super User

Hi @dakotaperryman,

Grouping/Binning is indeed a feature, but only available in Power BI Desktop. You can't add bins in the service.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @dakotaperryman ,

 

End user who has edit permisson can edit the report. But it is not supported to create new groups for the underlying data.

You could submit this as an idea.

https://ideas.powerbi.com/ 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
nickyvv
Super User
Super User

Hi @dakotaperryman,

Grouping/Binning is indeed a feature, but only available in Power BI Desktop. You can't add bins in the service.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Thanks Nick for your input. Is there any workaround that you could think of? Even if it was a totally seperate application? Maybe a PowerApp that allows them to create their bins, and stores them in our DB which will in turn create them in the dataset? Sounds complex, but maybe doable?

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors