Microsoft Power BI Cookbook

First purchase date grouping

In this example, the Customer dimension table has a First Purchase Date column with over 1,000 distinct date values. The business wants the ability to segment customers based on this date in report visualizations.

1. In report view of Power BI Desktop, select the First Purchase Date column in the Fields list.
2. With the column selected, click New Group from the Modeling tab in the toolbar.

• Alternatively, you can right-click the column and select New Group
• The groups dialog appears as follows, given the Date datatype:

Default groups dialog for first purchase date column: 21 day Bin size

By default, the groups feature ...