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.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

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!

Top Solution Authors
Top Kudoed Authors