Data Groups

Lists

Lists are typically used in Power BI to create a dropdown list or slicer that allows users to make selections from a predefined set of values. This helps in filtering or focusing on specific data points within a report.

User Interface

1. Table Name: Name of the table storing list related data

2. List Name: Identifier for a specific list within the table.

3. Field: Attribute or dimension associated with the items in the list

4. Group: A category or classification that organizes items in the list

5. Members: Items included in the group belonging to the list.

Bins

Bins are used for creating discrete groups or intervals for numeric or date/time data. This is particularly useful when you want to categorize continuous data into specific ranges or buckets.

User Interface

1. Table Name: Name of the table containing the data and associated bins.

2. Bin Name: Identifier for a specific data bin within the table.

3. Field: Attribute or dimension based on which data is binned.

4. Bin Type: Classification or type of the bin (Size of bins or Count of bins)

5. Bin count: Number of bins to be created

6. Bin Size: Range or size of a particular bin.

When the Bin Type is "Size of Bins", Power BI asks the user the Bin Size. When the Bin Type is "Bin Count", the user can set the Bin Count.