Power View in Excel 13 Part 2

In the previous post of mine, I mentioned how we can create a Report in Excel 13, by using the Power View command that is available. In this post, I will mention how we can modify the Report that we have created by using the Design tab that appears.

Once we click in the Report, the Design tab appears as shown in the image below. The Design tab is separated in different areas where we can modify the report and which are the following:

Switch Visualization, Tiles, Slicer, Options, Number, Text and Arrange

Power View Design Tab

Switch Visualization Area: By using this area we can switch the visualization of our report. The visualizations types that are available are the following:

Switch Visualization

Table: We can switch the visualization for this data region to a tabular visualization. The types that are available are the following:

Table

  • Table
  • Matrix
  • Card

Bar Chart: We can switch the visualization for this data region to a bar chart. The types that are available are the following:

Bar Chart

  • Stacked Bar
  • 100% Stacked Bar
  • Clustered Bar

Column Chart: We can switch the visualization for this data region to a column chart. The types that are available are the following:

Column Chart

  • Stacked Column
  • 100% Stacked Column
  • Clustered Column

Other Chart: We can switch the visualization for this data region to another type of chart. The types that are available are the following:

Other Chart

  • Line
  • Scatter
  • Pie

Map: We can switch the visualization for this data region to a map. The type that is available is the following: In order to use the Map visualization we must be connected to Internet.

Map

Tiles Area: We can view our data as a series of tiles. The types that are available are the following:

Tiles

  • Tiles
  • Tiles Types: Tab Strip and Tile Flow

Tile Type

Slicer Area: We can convert our data to a Slicer.

Slicer

Options Area: We have available some other options about visualizing our data and which the following are:

Options

  • Card Style: We choose a style for our card, either Card or Callout.

Card Style

  • Show Levels: We choose the number of levels to display. We can choose either one of the following depending on the adjustments that we have made:
  • Rows – Show All Grouping Levels At Once
  • Rows – Enable Drill Down One Level At A Time
  • Columns – Show All Grouping Levels At Once
  • Columns – Enable Drill Down One Level At A Time

Show Levels

  • Totals: We can choose either to display total or subtotals. We have available either None or Rows.

Totals None

Number: We can change the display of our data. For example we can change the display of how number or dates will appear. We can change the accounting number format, to increase or decrease the decimal places, to apply percentage format or to apply comma style for thousands seperator.

Number

Text: We can increase or decrease the size of the font.

Text

Arrange: If we have objects in our report and once it is selected we can either do one of the following:

  • Bring Forward
  • Send Backward

Arrange

Depending on where we click on our report, the Design tab might disappear from the ribbon and the Text tab might appear, so all we have to do is to click somewhere in our Report in order for the Design tab to appear again.

In my next post I will mention on other issues that we might find by using the Power View command in Excel 13, and how can we also print the Report that we have created.

Below you can check out the video describing the Design tab for modifying our Power View Report in Excel 13.

Power View In Excel 13 Part 2

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 28, 2014, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Power View in Excel 13 Part 2.

Comments are closed.