Easy Grouping Or Binning with Power BI - No Code!

Easy Grouping Or Binning with Power BI - No Code!

BI Gorilla

4 года назад

22,905 Просмотров

This video focuses on grouping or binning in Power BI. This method does not use any coding and is part of the DA100 certification.

Master Functions and Syntax in M
https://powerquery.how

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.

Website: https://gorila.bi

SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_confirmation=1

LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: https://facebook.com/BIGorilla/
Twitter: https://twitter.com/rickmaurinus
LinkedIn: https://linkedin.com/in/rickmaurinus/

Thank you for your support!


#PowerBI #Binning #BIGorilla

Тэги:

#Power_BI #Bin #Grouping #List #SWITCH #Hierarchy #Power_BI_Desktop #Business_Intelligence #ExcelGorilla #Business_Analytics #Excel_Gorilla #BI #PowerBI #PowerPivot #DAX #Excel #Learn_Powerr_BI #Binning #Group
Ссылки и html тэги не поддерживаются


Комментарии:

@ersahihlamr8734
@ersahihlamr8734 - 11.05.2020 17:58

Great video!

Ответить
@barttitulaerexcelbart9400
@barttitulaerexcelbart9400 - 11.05.2020 20:07

Thanks Rick. This was rather difficult in the past!

Ответить
@LouRainaldi
@LouRainaldi - 16.12.2020 19:18

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

Ответить
@stflytics2371
@stflytics2371 - 08.03.2021 10:04

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

Ответить
@johnrozmail
@johnrozmail - 02.05.2021 22:50

Very well explained sir thank you

Ответить
@sebguy1588
@sebguy1588 - 03.05.2021 18:18

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!

Ответить
@silasdasgupta9719
@silasdasgupta9719 - 05.05.2021 07:15

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

Ответить
@SoNJFF
@SoNJFF - 18.05.2021 02:31

Great stuff, thanks

Ответить
@cmkhoo
@cmkhoo - 29.06.2021 07:23

great video :)

Ответить
@mahesh-wt4vh
@mahesh-wt4vh - 27.07.2021 16:33

Great explanation... Thanks for your help

Ответить
@ritukumari-rj6qv
@ritukumari-rj6qv - 10.08.2021 23:16

Thanks for sharing this...

Ответить
@johng5295
@johng5295 - 31.08.2021 11:54

Great content.

Ответить
@ankurmaheshwari3625
@ankurmaheshwari3625 - 15.09.2021 12:31

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.

Ответить
@ClickbyClickus
@ClickbyClickus - 25.11.2021 02:21

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

Ответить
@mnowako
@mnowako - 07.01.2022 23:19

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! 👍

Ответить
@venkateswarlubhojanapu1473
@venkateswarlubhojanapu1473 - 14.02.2022 12:24

Excellent explain sir

Ответить
@w13ken
@w13ken - 27.04.2022 13:38

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.

Ответить
@StefanoVerugi
@StefanoVerugi - 22.06.2022 09:55

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

Ответить
@nagsiva2843
@nagsiva2843 - 07.07.2022 14:24

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

Ответить
@mainstreetvictory7689
@mainstreetvictory7689 - 04.09.2022 00:04

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:

<$10m,
$10M < $20M
$20M < $50M
$50M < $100M
$100M < $150M
$200M < $250M
$250M < $500M
$500M < $1bn
>$1bn

BUT, THIS IS WHAT POWER BI IS DOING WHEN I TRY TO CREATE THE LIST

<$10m,
$100M < $150M
$10M < $20M
$20M < $50M
$50M < $100M

See, it sends it back to the beginning. Then when i make a slicer with this group, it's in the WRONG order and I cannot fix it. Why does Power BI do this?

Ответить
@Sandroider
@Sandroider - 12.12.2022 13:08

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

Ответить
@bharathreddy4267
@bharathreddy4267 - 12.04.2023 05:28

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

Ответить
@julie_chen
@julie_chen - 25.10.2024 09:52

👍👍👍👍🙏🙏🙏🙏

Ответить