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? (this blog)
- Creating your first Power View report
- Creating and formatting basic visualisations (tables)
- Text boxes and images in Power View
- 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.
Overview - what is Power View?
Power View is an add-in included within Excel 2013 and later versions, which allows you to create reports integrated within Excel workbooks. Here's an example:
This report contains a slicer, a matrix and a chart.
Power View reports show up as tabs in the workbook:
This Power View report is just another tab in the worksheet.
The advantage of Power View is that it allows you - very quickly - to create reports with any layout, combining tables and charts and supporting drill-down. The disadvantage is that the formatting supported is pretty rudimentary (and it seems a bit buggy to me).
So now I've whetted your appetite, let's begin the tutorial proper with a look at how to create your first Power View report!