PowerBI: beginning

To make a pie chart of profit divided by payment type you do the following:

• Legend: SUM of Profit

  Values: Payment Type

• Legend: AVERAGE of Profit

  Values: Payment Type

• Legend: Payment Type

  Values: AVERAGE of Profit

• Legend: Payment Type

  Values: SUM of Profit

• Legend: Payment Type

  Values: COUNT of Profit

To make a KPI card you need to add: Value, Minimum, Maximum, Target Value

• True

• False

Draw a Gauge from 0 to 100 with 80 as Target Value and 70 as Value

To display categories side-by-side in column/bar chart for better comparison, you use

• Clustered

• Stacked

To see distribution of Customers by Membership Category in a bar chart you do this:

• Y-axis: Membership category

  X-axis: SUM of Customer ID

• Y-axis: Membership category

  X-axis: COUNT of Customer ID

• Y-axis: Customer ID

  X-axis: Membership category

• Y-axis: COUNT of Customer ID

  X-axis: Membership category

• Y-axis: Membership category

  X-axis: COUNT DISTINCT of Customer ID

Draw a stacked bar chart

To divide some charts into several charts by category, we use:

• Legend

• Small Multipliers

• Values

• Tooltips