Join Ron Davis for an in-depth discussion in this video Adding Power View visualizations, part of Creating Excel Power Pivot and Power View Dashboards.
- OK, now we're going to look at Power View, and I'm on the tab that we've created created for Power View. That really wasn't necessary. I just did that so that we would have a reference point when we were building out the spreadsheet, as you'll see. First, Power View is a download and you need to install it. You can just search Microsoft for Power View and bring it in. You also need Silverlight. Again, search on Microsoft and download and install Microsoft Silverlight, they're both free. To make sure it's turned on, I'm gonna go into File, and again we'll go into Options, our usual, Add-Ins, COM Add-Ins, and Power View is enabled.
That's all we wanted to see. If you notice right now, there's no Power View tab. So don't let that concern ya. We'll go over to Insert, and here it is. Now when we click Power View, we have automatically started up Power View and it has now turned on a Power View tab. And if you notice, it installs a Power View sheet down here. So we can just take this existing sheet, and delete it on out, and use this one down here. I'll rename it Power View.
So now our placeholder is gone and we've got something we can work with. So the first thing we're going to do is get some information. So let's go over to Fact and expand that. And let's take Sales Year-To-Date. Now just put a check into the box. That drops me down here into the fields. I've got Sales Year-To-Date, and if you notice, let me expand this out a little bit. Here we go, we've got a very generic Sales Year-To-Date. If I move up to Map and switch visualization, which is the power behind Power View, I now am overlaid with a map of the world.
And of course, the title, the entire sales, or whatever it was, 878 million. But to put that in sense, in a map, I'm gonna come down and put some location information. So I'm gonna go into Geography, and let's take Region/Country name, and drop that down here so we can get some color. Now I have China, Germany, and the United States. And if I take State/Province Name, and dropped that down the locations, I've now zoomed in. If you hover over, you'll see we have different information popping up.
If I want to add a filter, let's say, I take Continent Name, put that up here on a filter, and of course, if I have All, and I have All, otherwise if I go down there just to North America, I show just North America. So there is very easily filtered in here. Now perhaps this information isn't as informative right here in a map as you'd like it to be. So we can switch it out. We can select Column Chart, Stacked Column, and I've got a different way of looking at this information.
Bejing, Berlin, and Maryland are just happen to be the contrived geographical locations that we put in. These really, we contrived this data for this demonstration. Stacked Bar just switches me on over to a stacked bar. You can further enhance Power View by playing with it, you can add other filters, let's do that. Let's see if we can find Product, which is, let's do Product Category, and expand that down, and let's take Product Category Name, and move that down here into Filters.
And we'll just go, let's see, we've got Continents, either everything is selected or, It's not just one or two, more are selected. Let me show you. North America and Asia, OK, and now I can select cell phones, and you see it's dynamic. It changes 23 million and change. And if I switch to computers also, notice the visualization changed. So now I've got 93 million, etc. So this is very handy for the individual user to come through and configure.
What you want to do with Power View is contrast that back over to these graphs, these graphs that you put onto your dashboard. See if Power View will do a better job for ya. Power View is emerging technology and it's certainly something you want to take a look at.
- Dashboard design guidelines
- Importing data
- Relating data
- Creating calculated fields and columns
- Creating KPIs
- Adding a linked table to the data model
- Creating PivotTables and PivotCharts
- Adding Power View visualizations
- Formatting with color
- Reviewing the completed dashboard