Easy Grouping Or Binning with Power BI - No Code!

[@StefanoVerugi]

I've been doing binge watching on Power Query/BI for some time now and you are, at least for me, among the best thank you

[@bharathreddy4267]

This is what I'm exactly looking for, thankyou very much

[@w13ken]

A helpful video Rick, thanks. I have used Data Group lists before but binning in this way was new to me. Disadvantages for Lists are, as you described, they don't work well for unknown values and for Binning, it seems, the bin value takes the name of the lowest bin value so it lacks the flexibility seen in the DAX Switch group naming.

[@stflytics2371]

Hi Rick, great content and thanks for sharing this. You have a very pleasant way to explain something, keep up the good work!

[@barttitulaerexcelbart9400]

Thanks Rick. This was rather difficult in the past!

[@BIGorilla]

Thanks for watching Bart. It's the tiny things that make life easier!

[@mahesh-wt4vh]

Great explanation... Thanks for your help

[@ritukumari-rj6qv]

Thanks for sharing this...

[@johnrozmail]

Very well explained sir thank you

[@LouRainaldi]

Great video, thanks for sharing this! This is very useful

[@BIGorilla]

My pleasure!

[@venkateswarlubhojanapu1473]

Excellent explain sir

[@silasdasgupta9719]

Nicely explained, Thanks and it's work properly. Is there any way to do like same for date field? Looking for your response. Regards.

[@BIGorilla]

Hi Silas. What kind of grouping would you like to do? I think a lot of your date groups would better be made in dax or Power Query

[@johng5295]

Great content.

[@BIGorilla]

Thanks 🙏

[@ersahihlamr8734]

Great video!

[@BIGorilla]

Happy grouping and binning!

[@sebguy1588]

We need to create groups based on conditions. For example, we want to groups contracts between same vendor and cost centre that occurred within a set time frame (ex: 1 month). Then we would need to assign a "group number" for each of those. Where should I orient my research? Will I need DAX for such a process? Thanks for sharing the wisdom!

[@SoNJFF]

Great stuff, thanks

[@BIGorilla]

Thanks Jay, happy to help!

[@ClickbyClickus]

Do you all have an example site that you worked on? Sounds interesting

[@Sandroider]

How to deal with live connections since grouping is not available?

[@nagsiva2843]

May i know the difference between normal grouping feature and group by bin ?

[@mnowako]

Superb! I have always been using measures for grouping but those metods look quite handy and easy to use. I like the one with calculated column as well (the dynamic one). Thank you! 👍

[@cmkhoo]

great video :)

[@mainstreetvictory7689]

PLEASE HELP I'm trying to make revenue bands using groups. Every time I get to making a FIFTH group as a LIST, it automatically sends that group back to the second placing and then when making a slicer with that grouped list, it's NOT in the correct order so i want my grouped list to look like this: $1bn BUT, THIS IS WHAT POWER BI IS DOING WHEN I TRY TO CREATE THE LIST

[@julie_chen]

👍👍👍👍🙏🙏🙏🙏

[@ankurmaheshwari3625]

Superb Videos, Really like the way you explained all your videos and your expertise on DAX. Can i get your email id, Need your help on some points.

[@BIGorilla]

Appreciate the support. Drop me a note at [e-mail]. Cheers, Rick