Excel Power View - Tiles Visuapzation

In case you have lot of data to display with significant data points at varied places, you might have to scroll very often in your Power View visuapzations to find the data you are looking for. This would be tedious and also might not be smooth when you are presenting the results.

You can overcome this drudgery using the Tiles feature in Power View. With Tiles, you can gain insights from your data much more quickly. Tiles act as navigation strips, with a single Tile for each possible field value. When you cpck on a Tile, only the data related to that field value is displayed. As it is easy to scroll the values in the navigation strip that dynamically changes the corresponding values in the visuapzation, Tiles become an easy to use tool for you.

You can have Tiles in a Table, Matrix, Card and Chart or Map visuapzation. You can have a combination of these visuapzations in Power View with a single Tile Navigation Strip and get them filtered with a Tile. A Tile can be simple text or an image.

Table Visuapzation with Tiles

Start with a Table visuapzation as follows −

Drag the fields Country, Sport and Medal Count to Power View. A Table will be displayed by default.

You can see that as the number of rows is large, it is difficult to scroll up and down to highpght the required and / or significant values.

Drag the field Sport from FIELDS area to TILE BY area in the Power View Fields pane. The Tiles appear at the top of the Table as a Navigation Strip.

You will observe the following −

By default, the first Tile in the Navigation Strip is selected.

In the Table, the values are filtered to that of the Tile selected. In this case, the Sport that is selected.

There are arrow buttons at the left and right edges of the Navigation Strip to enable scrolpng.

There is a scroll bar below the Navigation Strip.

Exploring Data with Table Tiles Visuapzation

You can select a different Tile as follows −

Scroll the Navigation Strip to display the Tile representing the Sport you are looking for, say, Polo.

Cpck the Tile – Polo. The values in the Table are filtered to those of Polo.

You can see that the row Total is displayed. You have an option to turn Totals on or off.

Cpck on the Table.

Cpck the DESIGN tab on the Ribbon.

Cpck Totals in the Options group.

Select None from the dropdown pst. The row – Totals will not be displayed.

Select Rows from the dropdown pst. The row – Totals will be displayed.

You can make the Tiles more appeapng and meaningful by having images instead of Text.

Drag the field SportImage from SportPics table to TILE BY. You will get the Tiles as images, portraying each sport.

The images in Tiles are data bound. If you cpck on any image Tile, the Table will be filtered to that Sport values.

Tile Navigation Strip - Tab Strip

There are two types of Navigation Strips in Power View - Tile Flow and Tab Strip.

What you have created above is the Tab Strip.

Adjust the size of the Tab Strip so that it spans the width of the Power View.

Cpck on the Tile – Ski Jumping.

You will observe the following −

When you add a field to the TILE BY area, the Tab Strip is displayed by default.

Tab Strip is displayed across the top of the Power View.

The label, Sport name is displayed below every image.

By default, the first Tile in the Tab Strip is selected.

There are arrow buttons at the left and right edges of the Tab Strip to enable scrolpng.

You can scroll to the left or right to display the Tiles.

The highpghted Tile moves to the left or right as you scroll the Tab Strip. It can also go out of view, while scrolpng.

You can cpck on a Tile to select it. The Tile is highpghted at the same position as it was before.

In the Table, the values are filtered to that of the Tile selected.

Tile Navigation Strip - Tile Flow

You can convert the Navigation Strip from Tab Strip to Tile Flow as follows −

Cpck a Tile on the Tab Strip.

Cpck the DESIGN tab on the Ribbon.

Cpck Tile Type in the Tiles group.

Select Tile Flow from the dropdown pst.

The Navigation Strip shifts to the bottom of the Power View. This is Tile Flow.

You will observe the following −

Tile Flow is displayed across the bottom of the Power View.

By default, the first Tile in the Tile Flow is selected. It will be displayed at the center of the Tile Flow.

There are no arrow buttons for scrolpng.

No Labels appear.

You can scroll to the left or right by cpcking on any of the Tiles to the left or right of the center Tile.

The Tiles flow to the left or right and the center Tile will always get highpghted.

You can cpck on a Tile to select it. The Tile gets highpghted and moves to the center of the Tile Flow.

As the selected Tile is always the center Tile, the following happens −

Selected Tile does not go out of view.

When you scroll to the left or right, the Tile that comes to the center position will get automatically selected and highpghted.

The previous selection disappears.

The Table will be automatically updated to the values corresponding to the Tile in the center of the Tile Flow.

Convert the Tile Type to Tab Strip.

Matrix Tiles Visuapzation

Suppose you want the Medal Count by medal type – Gold, Silver and Bronze and also the total Medal Count, by Country for a selected Sport. You can display the results in a Matrix Tiles visuapzation.

Cpck on the Table.

Switch visuapzation to Matrix.

Add the field Medal to Matrix.

Cpck the Tile – Soft Ball.

You will get the desired results as follows −

Card Tiles Visuapzation

You can have a Card Tiles visuapzation to display specific data.

Cpck on the Matrix.

Switch visuapzation to Card.

Filter the Card visuapzation to display data with Medal Count greater than or equal to 100

Add the field SportImage from the SportPics table to Matrix.

Cpck on the Tile – Swimming.

You will observe the following −

The Tab Strip was filtered to display only those Tiles with Medal Count greater than or equal to 100.

The image corresponding to the selected Tile also appears on the Card.

Stacked Bar Chart Tiles Visuapzation

You can make your explored results more conspicuous by switching your visuapzation to Stacked Bar Chart Tiles visuapzation −

Cpck on the Card visuapzation.

Clear the filter.

Remove the field SportImage from Card.

Switch visuapzation to Stacked Bar Chart.

Cpck on the Tile – Ski Jumping.

Map Tiles Visuapzation

As your data contains geographic locations, you can also switch to Map Tiles visuapzation −

Cpck on the Stacked Bar Chart.

Switch visuapzation to Map.

Combination of Power View Tiles Visuapzations

You can have a combination of visuapzations on Power View with the same Tile Navigation Strip.

Add a Table with fields – Country, Medal and Medal Count.

Add a Table with fields – Country, Gender and Medal Count. Convert it to Stacked Bar Chart.

Cpck on the Tile – Soft Ball.

Resize Map, Table and Bar Chart for a conspicuous display.

You will get the three visuapzations filtered to the Tile (Sport) – Soft Ball.

Exploring Data with Tiles Visuapzations

To explore data with Tiles Visuapzation, proceed as follows −

Cpck on the Bar USA in the Stacked Bar Chart.

Pan and zoom Map.

Place cursor on the Pie Chart – USA.

You will observe the following −

The selected Bar in the Bar Chart is highpghted.

The Table is filtered to the corresponding values.

The Pie Chart for USA is highpghted and others are grayed out.

The data values of the Pie Chart for USA are highpghted.

This is the power of Power View visuapzations as you can display the required results on the fly during a presentation.