Open In App

How to Insert or Show Power View in Excel?

Improve
Improve
Like Article
Like
Save
Share
Report

Power View is one of the features of excel, which enables us to visualize, explore and present large data sets and encourage ad-hoc reporting. The larger data sets can be easily visualized and analyzed in excel using the Power View and this data visualization is dynamic which helps to present the data within a single power view ad-hoc report. Ad-hoc, a Latin word used for “to this”, is also understood to be “as needed” or “as required”. When the reports are created on request it is termed ad-hoc reporting.

Steps to Insert Or Showing Power View

Let’s see how we can insert the power view in our excel document.

Step 1: Adding Power View. By default, Power View is not added to the excel ribbon (tools tab). In order to add it, we need to customize our ribbon. For this, we can use any tab(here, in this example we are using data-tab) Right-Click > Customize the Ribbon

Adding-power-view

 

Once we click on the Customize the Ribbon option, excel will open a popup window where we are required to set the Power View option.

Customizing-ribbon

 

As we can see, we do not have a Power View option in our Data menu.

Step 2: Creating A New Group. In this step, we will create a new group for our Power View option. For this Select Data > New Group. This will create a New Group in the Data menu.

Creating-new-group

 

Step 3: Rename Group. In this step, we will rename our group. For this Select New Group > Rename. This will open a popup window to rename the group that we have created. (Here, we have renamed the group to Power View).

Renaming-group

 

Once we click OK, our group will be renamed to Power View.

Step 4: Adding Command. In this step, we are required to add command to our Power View group. For this Select Power View > Choose commands from > All Commands.

Adding-commands

 

After choosing All Commands from the drop-down list, we need to scroll-down and choose the Power View option.

Customizing-ribbon

 

After selecting Power View option from the All Commands tab, we need to click on Add button this will include Power View in our custom Power View group, and then click on the OK button.

Adding-power-view

 

Step 5: Output. Once we click on OK button, excel will add Power View to our selected tools tab. (Here, it is in Data).

Power-view-added

 


Last Updated : 04 Jan, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads