Using a pie chart
A pie chart displays each value as part of a pie or donut representing its percentage of the total. Multiple hierarchies and levels can be displayed by a pie chart as multiple rings, which is sometimes called a sunburst.
2. Add a pie chart from the toolbar
To add a pie chart to your dashboard, go to the toolbar, click Data Visualization, and then select Pie / Sunburst. An empty pie chart is added to the canvas.
Go to the Explore window and expand a data connector. Drag a measure column onto the empty pie chart. The chart will show a single pie slice representing 100% of the total.
Next, add a row hierarchy by dragging the sales territory Name column onto the pie chart. You'll see the pie chart animate into multiple slices where each slice corresponds to the percentage of total for each row hierarchy value (e.g., territory).
Switch to View mode and hover over a pie slice to see a tooltip showing the measure value and corresponding percentage.
If the row hierarchy added to the pie chart has multiple levels, you can drill down, change the level, or access other metric set functions by right-clicking (or long-tapping) on a pie slice (data point) in View mode.
3. Re-visualize as a pie chart
You can re-visualize a table or other type of data visualization from its context menu. Select the Pie/Sunburst option and the visualization will be changed to a pie chart accordingly.
4. Create a sunburst chart
A sunburst chart displays multiple hierarchy levels using concentric rings. The innermost rings correspond to the top hierarchy levels (e.g., years or product category) whereas the outermost rings correspond to the bottom hierarchy levels (e.g., months or product subcategories). As you move outward from the center of a sunburst chart, the pie pieces get broken down into smaller and smaller pieces. Sunbursts are considered similar to treemaps but with a different layout.
To create a two-level sunburst chart, first add a measure to an empty pie chart.
Drag the top hierarchy level onto the chart. This will form the inner ring.
Drag the bottom hierarchy level onto the chart. This forms the outer ring and completes the sunburst chart.
If your hierarchy has multiple levels, you can also right-click a pie slice in a regular pie chart and choose Expand. This displays the original pie chart plus a new outer ring containing just values you expanded in the next level. See Expand and collapse hierarchy members for details and examples.
4.1. Multiple row hierarchies
Instead of adding different levels from the same hierarchy, you can also create a sunburst chart by adding multiple row hierarchies (e.g., add Product hierarchy first, and then add OrderDate hierarchy).
4.2. Multiple measures
It is also possible to add multiple measures to a pie chart. This will result in a ring for each measure, as well as a separate series for each measure. However, this type of visualization is generally not considered to be a sunburst and there is no guarantee that the slices of one series (ring) will match up with the slices of another series.
When you add a legend for a pie chart, a legend item is generated for each pie slice (data point) instead of each series or grouping.
Pie-specific properties can be found on the pie chart's series. Open the Properties window, and click Series 1.
Then click Layout to see pie-related properties.
5.1. Outer Size
The Outer Size property specifies the size of the outer edge of the pie as a percentage of the available space.
5.2. Minimum Outer Size
The Minimum Outer Size property specifies the smallest percentage of the available space that the pie can be reduced to in order to fit labels.
5.3. Donut Hole Size
Use the Donut Hole Size property to create a hole in the center of the pie chart.
5.4. Start Angle
The Start Angle property specifies the angle of the start of the first pie slice, measured in degrees from North.
5.5. Label Text and Tooltip Text
Under the Text section, you can customize the Label Text and Tooltip Text properties for each series.
These properties accept regular text, as well as keywords such as [Member] for the hierarchy member caption. For additional information about available keywords, refer to the Formatting text article.