A tutorial on how to create Power View reports based on SSAS tabular models
Part four of a seven-part series of blogs

Power View is an add-in included within Excel 2013 and later versions. This tutorial shows how to create Power View reports based on Analysis Services tabular models.

  1. Overview - what is Power View?
  2. Creating your first Power View report
  3. Creating and formatting basic visualisations (tables)
  4. Text boxes and images in Power View (this blog)
  5. Filtering reports using tiles, slicers and filters
  6. Matrices and cards in Power View
  7. Charts in Power View

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 08 December 2015

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Text boxes and images in Power View

This part of my blog shows how you can add text boxes and images to your Power View reports.  Note that a report comes with one text box already added:

Title text box

Every new report automatically contains a title like this.

Often the easiest thing to do is to delete this title, and add text boxes when and where you want them!

Adding text boxes

To add a text box, choose this option on the Power View tab of the ribbon:

Text box

Adding a text box.

You can then type text into your text box (and resize it) in the (sort of) usual way:

Adding text box

Position the mouse on a corner of the text box and click and drag to resize it.

 

To format a text box, select it and choose this tab on the Excel ribbon:

Formatting a text box

Choose the TEXT tab on the ribbon.

 

You can then do a very limited amount of formatting:

Formatting ribbon

Wondering where all of the other standard formatting tools are? Me too.

 

Adding floating images/pictures

You can add pictures to a report in a similar way.  First choose to add an image:

Adding image

Choose to add a picture from the Power View tab.

When you choose an image, Power View will display it on your report:

Image added

Photoshop this is not. You can resize and move your image, but that's about it.

 

Adding watermark images

An alternative way to add an image is to choose this option:

Setting an image

You can set an image to be your watermark.

You can then choose a combination of the image position and transparency ratio to produce the desired (or otherwise) effect:

Tiled watermark

This is tiled with 80% transparency.

Here are the options for the image position and transparency:

Image position Transparency
Image position Transparency

And that's about it for text boxes and images!  Next we'll have a look at 3 ways to filter reports, using tiles, slicers or the filter window.

This blog has 0 threads Add post