Set Data Categories for fields in PowerPivot

In order for Power View to dynamically create reports based on underlying data, such as location, fields that contain such data must be properly categorized. Open the Excel Workbook we created in our earlier post. Create a Power View report For the Olympics data, let’s specify the categories for a few fields. In Power Pivot, select… More Set Data Categories for fields in PowerPivot