Open In App

Tiles Visualization with Excel Power View

Improve
Improve
Like Article
Like
Save
Share
Report

Let’s assume you need to present a lot of information with essential data points scattered throughout. To get the data you need in your Power View visualizations in this situation, you might have to scroll rather frequently. When you are presenting the results, this would be tiresome. Through the use of Power View’s tile function, you may escape this monotony. You can quickly uncover insights from your data using tiles. One tile serves as the navigation strip for each potential field value. Only information relevant to that field value is shown when you click on a tile. Tiles become more accessible due to the simplicity of scrolling the values in the navigation strip, which dynamically alters the corresponding values in the display.

Tiles Visualization

Let’s take a dataset as an example in order to understand Tiles visualization. This is the major dataset that will be used in this case.

dataset

 

Steps to Create a Tiles Visualization

Step 1: To make Tiles, begin with a table. Choose the following options: Country, Region, Festival, and Days. In Power View, a table with these fields is displayed.

table-with-fields-generated

 

Step 2: Drag the Country field from the Field area to the Tile By area in the Power View Fields pane. Then the Table’s top navigation strip is visible.

dragging-fields

 

The Tab Strip is automatically shown when a field is added to the TILE BY section. The Power View’s tab strip is visible across the top.

Step 3: Now as you can see the values are shown according to the selected tile. Here we have selected Canada Country. 

values-accordingly-to-tiles

 

A scroll bar is present below the Navigation Strip. The left and right borders of the Navigation Strip have arrow buttons that allow scrolling. 

Tile Navigation Strip – Tile Flow

As seen below, you may change the Navigation Strip from Tab Strip to Tile Flow:

Step 1: Click on a tile. Navigate to the design tab on the top of the ribbon, then in the tiles group select tile type and choose the Tile flow option.

clicking-design-tab

 

Step 2: Now as you can see in the tile flow the navigation strip is shifted to the bottom of the Power View.

tile-flow-shifted

 

By default, the first Tile is selected. It will be visible in the Tile Flow’s center. No scrolling arrow buttons are present. By clicking on any of the tiles to the left or right of the middle tile, you can scroll to the left or right. Now we are again going to switch to Tab Strip.

Matrix Tiles Visualization

Step 1: First click on the table then go to the design tab on the top of the ribbon and then in the switch visualization group click table and then choose Matrix.

choosing-matrix

 

Step 2: Now as you can see it converts the selected tile to a matrix.

tile-converted-to-matrix

 

Cards Tiles Visualization

Step 1: First click on the table then go to the design tab on the top of the ribbon and then in the switch visualization group click table and then choose Card.

choosing-card

 

Step 2: Now as you can see it converts the selected tile to a card.

tile-converted-to-card

 

Column Chart Tiles Visualization

Step 1: Select the fields Country, Days, and festivals. Then go to the design tab on the top of the ribbon and then in the switch visualization group click column chart and then stacked column.

selecting-stacked-column

 

Step 2: Now drag the country field to the Tile by area, days field in the value area, and festival field in the axis area.

dragging-country-field-to-tile

 

Step 3: Now you can see the chart shows the data according to the selection of the tile.

chart-with-data

 

Conclusion

We have learned about tiles visualization. Tiles become a simple tool for you to use since it is simple to scroll the values in the navigation strip that dynamically modifies the corresponding values in the display. In a table, matrix, card, or chart display, tiles might be present. These visualizations may be combined in Power View with a single Tile Navigation Strip and filtered using a Tile.



Last Updated : 20 Jan, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads