Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop

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, in this workbook of Olympics data, each tile shows data a specific discipline.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

In this article

Create a tile container

  1. Drag the field you want to use as your tile from the Field List and drop it in the Tile by box.

    Power View Tile

    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.

  2. 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.

    Tile with line chart and cards

    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.

Top of Page

Change the tile navigation strip

The tile container has two navigation strip types: tile flow and tab strip.

  • Click in the tabs area, and on the Design tab > Tile Type > Tile Flow.

    Power View Tile By Dropdown

Tile flow displays the navigation strip across the bottom of the tile container, with the selected tile always centered. Tab strip displays the navigation strip 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.

Add visualizations to the tile container

  1. Before adding more visualizations, you may want to drag the edge of the tile container to make it bigger.

  2. Click the blank area inside the container and then select fields for the visualization. Remember you create a table and 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, or 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 drag a visualization from outside the tile into the tile, it’s not in the tile container. It’s just on top of the tile, and its values won’t change when you click the different tabs in the tile.

Top of Page

Synchronize axes in a tile container

By default, Power View does not 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. Synchronizing a chart across the tiles makes it easier to compare the values in the chart from one tile to another.

  1. Select a chart in a tile container.

  2. On the Layout tab > Axes > click either or both:

Horizontal Axis the Same Across All Tiles

Vertical Axis the Same Across All Tiles

Tip: If values in the chart on one tile are much greater than in another, the chart with the smaller values may be harder to read.

Synchronizing the series means 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

Tiles in the Power BI app

Tile containers work a little differently in a workbook in the Microsoft Power BI for Windows app. If you’re designing a workbook for that, then keep these differences in mind:

  • Tiles use text or images as tabs in the navigation strip.

Note: Tiles with images and text as tabs show only the image on the tab.

  • If you set the Tile Type to Tile Flow, the tabs run along the bottom of the tile container.

  • When you first view the page, all tiles selected.

  • Selecting values in charts in a tile filters and highlights only visualizations in the tile, not on the rest of the page.

See Also

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!