Common Charts

Step 1: Import Data

• Open Power BI Desktop

• Click Get Data -> Excel/CSV

• Select your dataset

• Click Load

Step 2: Pie Chart

• Select Pie Chart

• Drag Party -> Legend

• Drag Votes -> Values -> Sum

• Go to Format -> Detail Labels

• Turn ON: Category, Percentage and Legend

• Rename title as Party Win Percentage

Step 3: Donut Chart

• Select Donut Chart

• Drag Party -> Legend

• Drag Votes -> Values -> Sum

• Turn ON: Data Labels , Percentage

• Rename title as Party Win Percentage

Step 4: Scatter Chart

• Select Scatter Chart

• Drag Votes -> X-Axis -> Sum

• Drag Margin -> Y-Axis -> Sum

• Drag Party -> Legend

• Drag party -> Details

• Turn ON Data Labels

• Go to the Further analyses visual -> Turn ON the Trend line

• Rename title as Votes vs Margin

Step 5: Treemap

• Select Treemap

• Drag Party -> Category

• Drag Votes -> Values

• Turn ON Data Labels

• Rename title as Votes by Party