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.