Power BI Grouping

Grouping means combining multiple items into fewer items. It helps us consolidate and summarize things to understand them at a higher level of granularity. Let us see how to use Power BI Grouping done easily and quickly. This is useful for Ageing Analysis, Bin or Bucket Analysis, week / custom date range analysis.

Creating Power BI Grouping

Power BI provides a simple and consistent mechanism of performing grouping for numbers, text and dates. All that you need to do is Right Click on the field name and choose Create Group.

New Group menu option

Two types of grouping is possible. Bins based or List based.

List based Power BI Grouping

For text data we can only group based upon the List type. It basically allows you to select two or more items and group them into a single category. Ungrouped items are shown as Other category.  For example here, we have divided the Segments into Risky and Safe.

Grouping text - risky and safe segmentsimage

Of course, if a new segment appears in future data, it will go under Others. You will need to edit groupings to repair such issues. This type of grouping should be used only if there are few groups and the data (in this case, segments) do not change often.

If there are too many categories and they change often, it may make more sense to have a separate table containing two columns – the segment and the classification. This table can then have a relationship on the Segment column and provide a more flexible and easier to maintain method of grouping.

Group icon

The newly created Group is added as a separate field with a special icon – which looks like two overlapping boxes.


Bins based Power BI Grouping

For numeric values, bin based analysis is more common. For example, for payments overdue, we usually perform ageing analysis by 30,60,90, 120 days overdue. This can be done easily using Bin based Power BI Grouping

Bin size setting of  30 for ageing analysis

This gives us ageing analysis easily.

ageing analysis

Ad-hoc grouping of numbers by using the List method is also available if required, but it is not very useful if there are too many numeric values. If there are few numeric values, ad-hoc grouping will be useful. For example, if you have just 10 unique values like a score, we can use List based grouping to classify them into low, medium and high categories.

List grouping for numbers

However, if there are too many numeric values, it is better to create a separate table to categorize numbers.

Dates based Power BI Grouping

Dates based grouping is available by default in Power BI. When you add a date type of column to a visualization, it automatically becomes broken down into Year, Quarter, Month and Days.

Bins can be created by specifying the size (as we saw with numbers)


This is very useful if you want weekly groups. By default, Power BI does not give you weekly breakdown. But if you group by days and choose bin size of 7, you get weekly grouping.

Number of bins

By default we create bins by specifying its bin or bucket size. But we can also use another method – by specifying the number of bins. This is very simple. The actual min and max of the column is found out and the range is divided into specified number of bins.


Custom bins require separate tables

Any custom bins require a separate approach.

For example, we want ageing from 0 to 30 and 31 to 45 then 46 to 90… this type of custom bin analysis requires you to create a separate table and then do the math by add a calculated column.

Similarly, for custom date grouping like custom weeks, calendar vs fiscal years and so on, we need a custom date table.

Three Time Zones in Outlook

Simple but useful stuff. Now, Outlook supports Three Time Zones in the Calendar. To set the time zones, right click on the time display in Calendar and choose Change Time Zone… or go to File – Options – Calendar – Time Zones.  If you work with customers or your own teams globally, this can be a very useful feature.

Set three time zones

How to select Three Time Zones in Outlook

One time zone is always shown by default – that is the current time zone – as per Windows regional settings. You can choose two more time zones. Remember to specify labels which are short and clear. If you use wrong labels, you will end up confusing yourself.

Three Time Zones were added in May 2018. Since many years, Outlook supported only two time zones.

The time zones are visible in the Day, Week and Work Week view. In the month view, there is no place to show the time portion.

Time showing Australia, Hong Kong and India time

Suppose, I have three time zones set – India, Hong Kong and Australia. What to do when I am actually visiting HK? Simple. Click the Swap Time Zones button. This cycles the time zones. Choose the first time zone to be the place where you are. That’s it.
Remember to reset it to your home time zone when you return to your base location.

Choose the desired time slot display

By default, Outlook shows one-hour time slots. Depending upon your work profile, you can make it more detailed. You can go down to 5 minute granularity. This is useful if you are using Calendar for managing lots of related activities like organizing an event calendar or a training program schedule.

Change time scale menu

There is a special 6 minute time slot display – for legal and other consultants who are billed by the hour. For them, dividing the hour into 10 slots of 6 minutes each is easier for calculating their charges rather than dividing it into 12 slots of 5 minutes each!

Arrange a meeting based upon customer convenience

In another related feature, while creating a new appointment, you can see other time zones. Click the Time Zone button in the New Appointment window.

Select the customer time zone and schedule the appointment as per their convenience. When you save the Appointment, it is translated automatically into your base time zone.

Unfortunately, WHILE you are editing the appointment, you can only see the time in the target time zone. But it is still better than manually calculating time zone offsets.