BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
- Overview - what is Power View?
- Creating your first Power View report
- Creating and formatting basic visualisations (tables)
- Text boxes and images in Power View (this blog)
- Filtering reports using tiles, slicers and filters
- Matrices and cards in Power View
- Charts in Power View
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:
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:
Adding a text box.
You can then type text into your text box (and resize it) in the (sort of) usual way:
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:
Choose the TEXT tab on the ribbon.
You can then do a very limited amount of formatting:
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:
Choose to add a picture from the Power View tab.
When you choose an image, Power View will display it on your report:
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:
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:
This is tiled with 80% transparency.
Here are the options for the image position and 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.