Grouping and Binning in Power BI

Поделиться
HTML-код
  • Опубликовано: 7 сен 2024
  • In this video, we will explore how to group and bin data in Power BI. Grouping allows us to combine similar items into categories for better analysis, while binning helps us to create defined ranges for numerical data. We will go through the step-by-step process of how to use these features in Power BI and show examples of how they can be applied to real-world scenarios.
    👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Angelica30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks...
    -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
    Next step on your journey:
    👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
    🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
    🔗Pragmatic Works Boot Camps: pragmaticworks...
    🔗Pragmatic Works Hackathons: pragmaticworks...
    🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
    🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
    🔗Pragmatic Works Blog: blog.pragmaticw...
    Let's connect:
    ✔️Twitter: / pragmaticworks
    ✔️Facebook: / pragmaticworks
    ✔️Instagram: / pragmatic.works
    ✔️LinkedIn: / pragmaticworks
    ✔️RUclips: / pragmaticworks
    Pragmatic Works
    7175 Hwy 17, Suite 2 Fleming Island, FL 32003
    Phone: (904) 638-5743
    Email: training@pragmaticworks.com
    #PragmaticWorks

Комментарии • 10

  • @oscarzamorano6901
    @oscarzamorano6901 10 месяцев назад +2

    Great explanation....very clear and concise

  • @kebincui
    @kebincui 7 месяцев назад

    Awesome tutorial, crystal clear and elegantly explained ❤🌹👍

  • @ranaasad6887
    @ranaasad6887 6 месяцев назад

    great thanks a bunch!!

  • @lakshmikolli4700
    @lakshmikolli4700 5 месяцев назад

    Life saver❤

  • @peterp5857
    @peterp5857 4 месяца назад

    Awesome! Very nice tutorial! Exactly what I was looking for!
    Is there any way to get categories into the group from another table? I have a list with values that I want consultants to choose from when they fill in a form. I would like to group those values/categories in advance so that when the consultants fill in a value that is previously unused in the form, but that is in the list it automatically is placed in the right group.

  • @nehachak
    @nehachak Месяц назад

    Thanks for the clear explanation. Is there any way to create Bins from 1 - 10 and not 0-9?

    • @AngelicaDomenech
      @AngelicaDomenech Месяц назад

      Glad you enjoyed this video! The built-in binning feature has some limitations. If you wanted to create more custom bins, you could make a conditional column using Power Query or using IF logic to achieve this with DAX.

    • @nehachak
      @nehachak Месяц назад

      Thanks ​@AngelicaDomenech understood
      I need it as a slicer in my report and something like 0-10, 0-20,0-40, etc...please let me know if there's any video of yours that can help me achieve this

  • @melodym5993
    @melodym5993 6 месяцев назад

    You're an awesome instructor, thank you! Quick question, I've not tried the binning, but it's a good idea for a new report i need to do in paginated reports, do the hierarchies flow into the query editor with the rest of the data columns/hierarchies, within the table of your dataset, or are they separated like measures?

  • @shaileshvishwakarma3418
    @shaileshvishwakarma3418 10 месяцев назад