Monday, April 10, 2017

How to use Grouping and Binning in Power BI

You can group your data into chunks for visualization purposes. Group is used for character fields and binning is used for numeric values.
Group
You can group data points to help you more clearly view, analyze, and explore data and trends in your visuals. The following example shows that how to group some cities into a group.

Binning
You can set the bin size for numerical and time fields in Power BI Desktop. You can use binning to right-size the data that Power BI Desktop displays. Binning is very useful in many purposes for example group into a range of data.

The following example shows that how to categorised into Payment due date.
In the same way, you can create a date data type fields with Bin Type as shown below.
Cheers! Uma

25 comments:

  1. Andhra Pradesh Engineering Agricultural and Medical Common Entrance Test AP EAMCET is a state level entrance

    examination conducted in the state of Andhra Pradesh for the selection of candidates into Engineering and Medicine and Agriculture courses. It is conducted

    by Jawaharlal Nehru technical Institute.

    Telangana State Engineering Agricultural and Medical Common Entrance Test TS EAMCET is a state level entrance

    examination conducted in the state of Telangana for the selection of candidates into Engineering and Medicine and Agriculture courses. It is conducted by

    Jawaharlal Nehru technical Institute (JNTU) on behalf of TSCHE.

    UPSEE is an acronym for Uttar Pradesh State Entrance Examination. Students who qualify UPSEE get admission to more than

    750 government college and private Institution in the state Uttar Pradesh. This exam is organized and conducted by A.P.J Abdul Kalam Technical University

    (AKTU) for admission to various Undergraduate and Postgraduate programme.

    IPUCET Exam stands for Indraprastha University Common Entrance Exam. This exam is conducted by Guru Gobind Singh Indraprastha University (GGSIPU). The

    IPU CET 2018 Exam is offering admissions to the Under Graduates and Post Graduates in the fields of Engineering, Dental,

    Medical and Law.

    JEE Main is one of the biggest entrance exams that is held every year. The JEE Main 2019 Entrance Examination is

    conducted by the CBSE. This year the CBSE is going to conduct the JEE Main 2019 on April 8th, 2019.

    The CBSE has finally published the Date-sheet of CBSE 10th 2018 Board Exam. The Exam will start from 5th March 2018. Here is the complete list of CBSE Results 2018

    The RRB has announced its Official Advertisement 2018 for Railway Junior Engineer.

    The Recruitment Board is offering approx. 5620 Vacancies for RRB JE. It is a great

    opportunity for those who are interested in the Railway Jobs.

    DMRC (Delhi Metro Rail Corporation) has released the notification for the various

    postsfor Assistant Manager in various fields, Office Assistant, Account Assistant, Stenographer and much more. The Department is providing over 1800 posts

    for the aspiring candidates. The online registration for the recruitment starts from 27th Jan 2018 to 26th Feb 2018 (23:59 pm).Check Here for complete details

    regarding the DMRC Recruitment 2018.

    Recently the RRB has declared the vacancies for the Railway Assistant Station Master

    (ASM). An approx. of 50,000 vacancies, positions are filled this year. full detailed information click here rrb asm recruitment 2018

    The RRB Recruitment Department is planning to release the dates for RRB Recruitment 2018 for the year 2018-19 in the month of January. The examination will be

    conducted after one or two months after the release of the notification. The RRB NTPC 2018 will recruit the candidates for various vacant posts in Technical

    and Non-Technical Categories.

    ReplyDelete
  2. Nyc info..
    Government Jobs offer an opportunity to turn your aspirations into reality. If you aspire to work in the mainstream and be a part of the nation's economic development, a job in the Government Sector may be the best option for you. Every year a number of job opportunities become available in the Government Sector.
    for more info:- sarkarijob.ind.in

    ReplyDelete
  3. • Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updatingMSBI Online Training

    ReplyDelete

  4. I appreciate your work on Hadoop. It's such a wonderful read on Hadoop tutorial. Keep sharing stuffs like this. I am also educating people on similar Hadoop so if you are interested to know more you can watch this Hadoop tutorial:-https://www.youtube.com/watch?v=1jMR4cHBwZE

    ReplyDelete
  5. Top 10 hot technologies of 2019 to make a good career in the upcoming year: https://www.youtube.com/watch?v=-y5Z2fmnp-o

    ReplyDelete
  6. What a fantastic read on Big Data Hadoop Tutorial. This has helped me understand a lot in Big Data Hadoop Tutorial. Please keep sharing similar write ups on Big Data Hadoop Tutorial. Guys if you are keen to knw more on Big Data Hadoop Tutorial, must check this wonderful Big Data Hadoop tutorial and i'm sure you will enjoy learning on Big Data Hadoop Tutorial.https://www.youtube.com/watch?v=nuPp-TiEeeQ&

    ReplyDelete
  7. I think Power BI is actually the best tool to simplify the most complicated and tough IT problems.

    Powerbi Read Rest

    ReplyDelete

  8. Enjoyed reading the article above, really explains everything in detail, the article is very interesting and effective. Thank you and good luck for the upcoming articles Learn power bi online training
    power bi online training Hyderabad
    power bi online training India
    power bi online course

    ReplyDelete
  9. ANALYTICS TRAINING HUB is a journey of humble beginnings with the sole focus aimed at equipping our clients with the necessary training & support to aid in educating them in multiple distinct data analytic tools courses in Delhi and ncr. we can provide our clients an in-depth knowledge of some of the world-renowned data analytic tools like Power BI, Tableau, QlikView, MS Excel, Python, R etc, which enables us to live up to the vision of our firm while making our clients efficient & capable.

    MIS Training in Delhi
    Microsoft Excel Course
    MySQL Course in Delhi ncr
    Excel VBA and Macros Course in Delhi
    Power BI Course in Delhi
    Tableau Course in Delhi

    ReplyDelete
  10. Hi Dear,
    Thanks for sharing such useful blog. Really! This Blog is very informative for us which contain lot of information about BI, I like this post. Please visit at "Power bi courses", i hope you may like our BI.

    Visit Here - https://portal.enterprisedna.co/p/enterprise-dna-membership/?affcode=78853_ume2zlih'

    Thanks, Regards,

    ReplyDelete
  11. Great Article!
    Get in touch with a Microsoft Power BI Partner to know more about the solution and its integration.

    ReplyDelete
  12. Thanks for sharing such a helpful, and understandable blog. I really enjoyed reading it.
    power bi training in ameerpet
    Power BI Online Training in Hyderabad



    ReplyDelete
  13. The article is very interesting and effective
    Informative blog and it was up to the point describing the information very effectively.
    Visit:Best power bi training institute in Hyderabad

    ReplyDelete
  14. Wow, this is amazing! You've really outdone yourself here.
    Micropython Training In Hyderabad

    ReplyDelete
  15. Your talent is truly inspiring. Keep up the great work!
    Micropython Training In Hyderabad

    ReplyDelete