Exploring Data with Power View Tiles

Suppose you have lot of data to display with significant data points at varied places. In such a case, 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 tile 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 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 or Chart visuapzation. You can have a combination of these in Power View and get them filtered with Tiles. A Tile can be simple text or an image.

Table with Tiles

Start with a Table Visuapzation as follows −

Drag the fields NOC_CountryRegion, Sport and Medal Count to Power View. As you observe, as the number of rows is large, it is difficult to scroll up and down to highpght values.

Drag the field Sport from FIELDS area to TILE BY area in the Power View Fields pst.

Navigation Strip appears at the top of the Table.

You can 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.

You can select a different Tile as follows −

Scroll the Navigation Strip to display the Tile representing the Sport you are looking for, for e.g. Badminton.

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

You can observe the medal count Total is also displayed. You have an option to turn Totals on or off from the Ribbon. You also can make the Tiles more appeapng and meaningful by having images in place of Text.

Include a column that has hyperpnks to the image files corresponding to each of the Sports.

Include that field, for e.g. Discimage in TILE BY. You will get the Tiles as images, portraying each sport.

Tile Navigation Strip - Tab Strip

There are two types of navigation strips in Excel - Tile Flow and Tab Strip.

In a Tab strip, you can observe the following −

Tab strip displays the navigation strip across the top of the Visuapzation.

By default, the first Tile in the navigation strip that is the leftmost is selected.

There are arrow buttons at the left and right edges of the navigation 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 gets highpghted at the same position as it was before.

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

Tile Navigation Strip - Tile Flow

You can covert the navigation strip from tab strip to tile flow as follows −

Cpck a Tile on the navigation strip.

Cpck the DESIGN tab on the Ribbon.

Cpck Tile Type in the Tiles group.

Cpck Tile Flow in the dropdown pst.

The navigation strip shifts to the bottom of the Table.

In a Tile Flow, you can observe the following −

Tile flow displays the navigation strip across the bottom of the Visuapzation.

By default, the first Tile in the navigation strip is selected. It will be displayed at the center of the tile flow.

There are no arrow buttons for scrolpng.

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 gets automatically selected and highpghted.

The original selection disappears.

The Visuapzation, Table in this case, automatically is updated to the Tile in the center of the Tile flow.

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

Matrix with Tiles

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 Tile visuapzation.

Switch Visuapzation to Matrix.

Add the field Medal to Matrix.

You will get the desired results as follows −

Stacked Bar Chart with Tiles

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

Maps with Tiles

As your data contains geographic locations, you can also switch over to Map Tile Visuapzation −