In this blog, we explore Power BI’s Data Groups feature, enhancing data visualization and interaction for report users.

Data Groups in Power BI: Power BI’s Data Groups efficiently organizes data. Compared to lengthier alternatives like grouping in Power Query or DAX Calculated Columns.

Binning Data for Visualization: Let’s discuss data binning for clearer visuals. Binning categorizes data into bands or ranges. For instance in the example below, grouping contract values from £5,000 to £100,000 into £5,000 bands.

Creating Data Groups:

  • Navigate to Column Tools > Data Groups > New Data Group.






  • Name* the (Column header) and choose “Size of Bins.”
  • Specify Bin Size (e.g., 5,000 for Contract values).

Result: This process adds ‘Contract Value (Bins)’ to your field list under data. Include it and the original ContractValue field in the report as a matrix to visualize how data has been binned.

Simplified Visualizations: Use this to method to simplify visuals. Create a Clustered Column Chart with the bin column on X-axis and sum of ContractValue on Y-axis to see revenue by group.

Upcoming Topics: Next, we’ll discuss date grouping, dynamic bin size adjustments for users, and crafting dynamic histogram charts in Power BI.

Tags: , , , ,