When you right-click within the report headers, a context menu displays. The header menu deals mostly with modifying the report results display by column. In contrast, the data context menu deals more with global report options. See The Powerview Data Context Menu.
To change an option from the heading context menu:
Right-click over the data column you want to group by and select from the menu.
You will see the action ready for confirmation in the Action Board. To apply this change immediately, click Apply in the Action board, otherwise do it after you have made all your changes.
Tip: If you don't want to apply multiple actions at once, you can click Immediate Refresh from the data context menu to apply your changes automatically.
The heading context menu contains the following options:
| Menu Option | Description |
|---|---|
| Show | Click Show and select any column that isn't visible, to display it. |
| Hide | Click Hide to remove the column selected on the report output. Once applied, any hidden columns appear in the Show list. |
| Group | Group the data by the column you clicked from. |
| Totals | Select one of your available options. For example, Count and DistCount. |
| Sort | Click either Ascending or Descending to sort the data by that column. |
| Reset Width | Click to reset the selected column to its default width. |
| Other Options | The options on your context menu may vary with report type and query. For example, Count columns may have the option to Render as DataBar. |