A Power Pivot Chart in Excel is a visual representation of data from multiple tables in a Power Pivot data model. It allows users to analyze, summarize, and filter large datasets efficiently. Charts are created from pivot tables, showing relationships, totals, and comparisons using value fields, legends, and axis field buttons.
Creation of Power Pivot Chart
Let's create a chart using Power Pivot on the following data model.
Step 1: Click the Home tab, which is visible above and click on the pivot table.
Step 2: Then click on the pivot chart.
Then a dialog box appears. Select a new worksheet and click ok. Then it will appear like the image below, which contains all the table names in pivot chart fields.
Step 3: Then click on the pivot chart fields (which contain table values) that represent the chart.
So by clicking these fields, the chart will appear according to their relation.
These are called value field buttons. Based on the data in these field buttons, the chart is prepared.
This is called a Legend. In this area sum of values is given. We can remove the legend and value field buttons. The icon at the left side bottom(which is named 'Name') is called Axis filed button.
Click on the + icon that appears right side of the chart then you can see the chart elements. Untick the boxes if you want them to hide.
We can change the style and color of the chart from this option.
Fields list
- The power pivot chart contains two tabs, Active and All.
- Active tabs consist of data tables that are added to the power pivot chart.
- All tabs consist of all the data tables in the data model.
Filters
By clicking the axis field button, a drop-down menu will appear. We can hide or unhide the values as we wish. There is also another method and we can drag the field to the filter area for filtering the values and search for the chosen report values. Then choose the values you want to hide.
