Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible. What should you do?
- Create a new aggregation that summarizes by employee.
- Create a new group on the state column and set the Group type to List.
- Create a new group on the state column and set the Group type to Bin.
- Create a new aggregation that summarizes by state.
With grouping you are normally working with dimensional attributes.
Here we add three new groups (East, West, and North) and add each state to the appropriate group.
C: You can set the bin size for numerical and time fields in Power BI Desktop.