Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Easy
Question 11
You are working in Power BI and need to create bins for the CustomerAge column. You need to configure a bin for CustomerAge to have a range between 20 and 60.
Which fields in the "Groups" dialog box would you need to modify to set this range?
-
A
Field and Name
-
B
Reset to Default and Bin Type
-
C
Group Type and Bin Size
-
D
Min Value and Max Value
Reveal correct answer
Correct answer: D
Explanation
Solution with Configuring Bin Range
You’re creating bins for the "CustomerAge" column in Power BI and need the bins to range between 20 and 60 (e.g., for a specific age demographic). In Power BI Desktop, select the Customers table in the "Fields" pane, right-click "CustomerAge," and choose "New Group." In the "Groups" dialog, since CustomerAge is numeric, "Group Type" defaults to "Binning." To set a range from 20 to 60, modify the Min Value and Max Value fields:
Set Group Type to Binning: Ensure "Binning" is selected (default for numeric fields like CustomerAge).
Adjust Min Value: Find "Min value" (below "Bin Type" in some UI versions, or inferred from the data range). If CustomerAge naturally ranges from, say, 18 to 80, change "Min value" to 20 to start bins at 20.
Adjust Max Value: Set "Max value" to 60 to cap bins at 60. Any ages above 60 (e.g., 65) are excluded or grouped as "Others" (depending on settings).
Set Bin Size or Number of Bins: Choose "Bin Type" as "Size of bins" (e.g., 10 for 20–30, 30–40, 40–50, 50–60) or "Number of bins" (e.g., 4 for equal splits: 20–30, 30–40, 40–50, 50–60). This works within the 20–60 range you’ve defined.
Apply the changes, and the new "CustomerAge (Bins)" field reflects bins only from 20 to 60—e.g., a bar chart shows counts for 20–30, 30–40, etc., ignoring ages outside this range.
Why This Works
"Min Value" and "Max Value" in the "Groups" dialog set the boundaries of the binning range, ensuring CustomerAge bins span exactly 20 to 60. "Bin Size" or "Number of bins" then divides this range, but without adjusting Min/Max, bins might extend beyond 60 or start below 20 (e.g., 18–28). The Microsoft grouping and binning documentation notes, “Adjust Min Value and Max Value to define the exact range for bins, controlling the scope of numeric data grouping.” This lets you tailor the bins to your 20–60 requirement precisely.
Why Not Other Options?
Group Type and Bin Size: "Group Type" (Binning) is necessary but doesn’t set the 20–60 range—it enables binning. "Bin Size" (e.g., 10) defines interval width within a range, not the range itself, per the docs.
Field and Name: "Field" (CustomerAge) is pre-selected, and "Name" (e.g., "CustomerAge (Bins)") labels the output—neither controls the 20–60 range.
Reset to Default and Bin Type: "Reset to Default" reverts settings (e.g., full data range), undoing your 20–60 goal. "Bin Type" (Size vs. Number) shapes bin division, not the range boundaries.
Min Value and Max Value are the fields you’d modify to lock the CustomerAge bins between 20 and 60, meeting your specific visualization need.
A.
Field refers to the column being grouped (e.g.,
CustomerAge).Name is simply the label assigned to the grouped output.
Neither is used to define or control the range of values.
B.
Reset to Default reverts settings but does not allow manual range selection.
Bin Type may influence how the bins are generated (e.g., fixed size), but it does not allow you to explicitly set a range like 20 to 60.
C.
Group Type determines the method of grouping (e.g., List or Bin).
Bin Size controls the width of each bin, not the start and end range.
You cannot directly define a specific range (20–60) using only these fields.
D.
Min Value and Max Value are the appropriate fields to configure when you want to explicitly set a bin range.
Setting Min = 20 and Max = 60 ensures the bin includes only values within that range for the
CustomerAgefield.This directly defines the lower and upper bounds of the data segment you're targeting.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
