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


View solution in original post

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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!