POWER VIEW has been deprecated. Now you must use Power BI Desktop
Presentation of Power View
Power View was a tool in Excel 2013 Pro Plus to create interactive dashboard.
Each element (chart, map, table of value) can interacted with the others.
For instance, if you select a slice of the pie chart, this will filter all the others element according to the selection
Technology of Power View
Power View has been developed with the technology Silverlight. Unfortunately, this technology has been depreciated by Microsoft in October 2012. So it was obvious that Power View in its original state couldn’t evolve.
In fact, in the same time, HTML5 was much more robust, quick and light than Silverlight. So it was necessary for Microsoft to develop a similar tool but base on HTML5.
Power View with Excel 2016
Power View is not visible by default in Excel 2016. Nowhere in the ribbon, you can find it.
For compatibility reason, Power View could be installed by activating the tool from the menu Options>Custom Ribbon
But, that was at the beginning of Excel 2016. It seems in 2018 that none of the Power View dashboard couldn’t opened.
What is the future of Power View?
In fact, now, the best way to create interactive dashboards is to use Power BI Desktop. And there is many reason for that:
- The tool is free
- You can connect to many different sources
- Manipulate easily your data (Power Query)
- Create your own measures (Power Pivot)
- You have tons of visuals to present your data
- Share easily your dashboards to a specific audience
Have a look at this example to understand the type of dashboard that you can do with Power BI Desktop.