Multiple Visualizations in Excel Power View

Multiple Visualizations in Excel Power View (Multiples or Trellis Charts) display the same chart in separate panels by category such as Country, Season, or Year. They share the same axes, making it easy to compare trends across groups.

Power View supports Line, Bar, Column, and Pie charts for better analysis.

Creating a Table

To create a Table in Power View, select the Power View region, choose the table Range from the Fields list, and select Year, Country, Season, and Events. A table with the selected fields and values will be displayed.

range-in-power-BI — Creating a table in Power View with selected fields: Year, Country, Season, and Events.

Multiple Visualizations using Bar Charts

To display Events by Country for each Season, start with a table containing Country, Event, and Season fields. Then go to the Design tab, select Switch Visualization, and choose Stacked Bar from the Bar Chart dropdown menu to create the visualization.

selecting-stacked-bar-chart — Stacked Bar Chart in Power View visualizing Events by Country for each season

Scatter Bar Chart with Vertical Visualization

In the Drag Field areas pane first drag the field Events to Value area, drag the field Season to Legend area and drag the field Country to Vertical Multiples area then it will show the scattered Bar chart in vertical visualization.

dragging-country-to-vertical-multiples — Vertical multiple Bar Charts displaying Events by Country and Season using stacked layout

Now you have a scattered Bar chart in vertical visualization. A Bar Chart appears with Events by Country and season. In the row chart, events are shown on X-axis.

scattered-bar-chart-created — Vertical Bar Chart view with Events on the X-axis, grouped by Country and Season

Scatter Bar Chart with Horizontal Visualization

If we want a scattered Bar chart in horizontal visualization, then for that we need to drag the field country to Horizontal multiple areas.

Dragging-country-to-horizontal-multiples — Creating horizontal multiple Bar Charts by dragging Country to the Horizontal Multiples area

Now you have a horizontal bar chart visualization showing Events by Country and Season. Events are plotted on the X-axis, and a horizontal scroll bar below the chart allows you to navigate across additional charts.

scattered-bar-chart-created-in-horizontal-visualization — Horizontal Bar Chart view with Events on the X-axis and scroll bar for navigating multiple charts by Country and Season

Multiple Visualizations using Column Charts

Follow the same steps to create a Column Chart. Go to the Design tab, click Switch Visualization, and choose Stacked Column from the Column Chart dropdown menu.

selecting-stacked-column-chart — Creating multiple visualizations using Stacked Column Charts to display Events by Country and Season

Now you have a scattered Column chart for multiple visualizations. A Column Chart appears with Events by Country and season. In the column chart, Events are shown on Y-axis.

scattered-column-chart-created — Multiple Column Charts displaying Events by Country and Season with values plotted on the Y-axis

Multiple Visualizations using Pie Charts

To create a Pie Chart, follow the same steps as before. Go to the Design tab, click Switch Visualization, and select Pie Chart from the Other Chart dropdown menu.

selecting-pie-chart — Generating multiple Pie Charts in Power View by selecting the Pie Chart option from the Other Chart menu.

In the Drag Field areas pane first drag the field Events to Size area, drag the field season to slices area and drag the field Country to Vertical Multiples area.

A Pie Chart appears with Events by Country and season.

pie-chart-created — Multiple Pie Charts displaying Events by Country and Season with segmented slices.

Multiple Visualizations using Line Charts

To create a Line Chart showing Events by Country and Year, start with a table containing Country, Event, and Year. Then go to the Design tab, click Switch Visualization, and select Line Chart from the Other Chart dropdown menu.

selecting-line-chart — Creating multiple Line Charts in Power View to visualize Events by Country and Year.

In the Drag Field areas pane first drag the field Events to Value area, drag the field Year to Axes area and drag the field Country to Vertical Multiples area.

A Line Chart appears with Events by Country and Year.

line-chart-created — Line Charts showing Events by Country and Year with year on the X-axis and Events on the Y-axis

In the Line chart, the year is on the X-axis, while the event values are on the Y-axis. The year is in the AXIS section of the Power View Fields box, while Events is in the VALUES area and the country is in the vertical multiples area.