The four types of navigation layout define the layout of the data in the visual
To apply these layouts to your report, simply click on Navigation under the Home tab and click on the navigation type of your choice.
Navigation Layout Type
In Pivot mode under the layout section 3 options are provided - Values on Rows, Values on Column and None
Values on Column:
Here the categories are arranged over the column to understand the values in detail through column view.
Values on Column
This option is also supported for custom data input column
Values under Rows:
By highlighting the categories over the rows, the values on the outlined row structure can be more easily understood.
Values on row
If you are on this mode ( Values on row) visual column dimensions will not be shown, only visual measure dimensions will be visible
Under values on row only Visual measure is available
The features of this navigation layout are –
The subcategories lie beneath the parent in the same column
Parent row is highlighted with bold text and larger row height. Check Display and Style to customize it.
Subtotals appear in the parent row. Check Total to manage these subtotals.
An example of report with Hierarchy Navigation is given below:
Hierarchy Navigation Layout
The features of Table Navigation are –
It displays data in a tabular format
It shows the headers of all row categories
There is no subtotal row in this layout
An example of a report with Table Navigation is given below:
Table Navigation Layout
The features of Stepped Navigation are –
It is a combination of table layout with expand/ collapse
On expansion, the subcategories move to separate columns and values are displayed accordingly
An example of a report with Stepped Navigation is given below:
Stepped Navigation Layout
The features of Drilldown Navigation are –
Parent row displays the number of children
On clicking a specific row, it will drill down to its lower level. And hides the other rows.
An example of the report using drill down navigation is shown below:
Drilldown Navigation Layout
Drilldown on International shows 2 Children