If you have to scroll a lot in your table visualizations to find the data you are looking for, you can use the tile feature in Power View to gain insights from your data much more quickly. Tiles act as navigation strips, with a single tile for each possible field value. When you click a tile, only data related to that field value is displayed. For example, if you have a dataset of fruit and you tile by color – selecting the “yellow” tile will display related data for fruits such as bananas and lemons.
Drag the field you want to use as your tile from the Field List and drop it in the Tile by box.
The tile navigation strip displays the values for that field.
Tip You can use images in the navigation strip in tiles. Read more about using images in Power View.
Click the tabs to move between the data for the different tiles. The data changes in the table according to the tile you select. All content in the container is filtered by the selected tile value.
Note You can also apply filters from the filters pane to one or more of the visualizations inside the tile container.
This tile container, filtered by category, uses the category image in the tile flow navigation, and contains a line chart and set of cards filtered for the category selected.
You can change the tile display from tile flow to tab strip. Click in the tabs area, and on the Design tab > Tile Type > Tile Flow.
Tile flow displays the tiles across the bottom of the tile container, with the selected tile always centered. Tab strip displays the tiles across the top of the tile container. You can scroll through the tiles by using the scroll bar, or you can click on the tiles.
To add more visualizations to the tile container, drag the edge of the tile container to make it bigger. Click the blank area inside the container and then select fields for the visualization. Remember that you start with a table, which you then convert into another visualization.
Note You can create a visualization outside the tile, copy or cut it, and then paste it into the tile container. You can also do the opposite; cut or copy a visualization from the tile container and paste it in the current view, in a different sheet, or in another tile container. However, if you try to drag a visualization from outside the tile into the tile, it’s just on top of the tile. Its values won’t change when you click the different tabs in the tile.
Synchronizing axes in tiles containers
By default, Power View does not automatically synchronize the horizontal and vertical axes, series, and bubble size in charts in a tile container. For each chart, it sets these scales based on the values in the chart on each individual tile. This makes each chart easy to read. However, it can be hard to compare values across multiple tiles if the scales are not consistent. You can choose to synchronize charts across the tiles to make it easier to compare the values in the chart from one tile to another. However, if values in one chart are much greater than in another, it can be harder to read the chart with the smaller values.
Synchronizing the series means that every value is in the legend for every chart, even if a value doesn’t exist in a specific chart. For example in a chart of items sold tiled by month, if the series is not synchronized, items in the Items list in the legend will vary, depending on what sold that month. If the series is synchronized, items in the Items list will be fixed, so even if an item didn’t sell that month, it will still be in the list.
Top of Page
Charts and other visualizations in Power View
Power View: Explore, visualize, and present your data
Power View and Power Pivot videos
Tutorial: PivotTable data analysis using a Data Model in Excel 2013
Top of Page