Open In App

Tiles Visualization with Excel Power View

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.



 

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.

 

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.



 

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. 

 

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.

 

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

 

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.

 

Step 2: Now as you can see it converts the selected tile to a 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.

 

Step 2: Now as you can see it converts the selected tile to a 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.

 

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.

 

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

 

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.


Article Tags :