Quizalize logo
placeholder image to represent content

Targets vs Actuals Chart in Power BI

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    What are the three components that make up the bars in the target vs actual chart?
    Deficit, Surplus, Supporting Bar
    Sales Variance, Target Variance, Average Sales Value
    Minimum Sales Value, Maximum Sales Value, Target Value
    Minimum of Sales Value and Target Value, Maximum of Sales Value and Target Value, Target Line
    30s
  • Q2
    What visualization type is used to create the target vs actual chart?
    Line and stacked column chart
    Line chart
    Bar chart
    Stacked column chart
    30s
  • Q3
    How are the blue and red bars created in the chart?
    The blue bar is the target value and the red bar represents the actual sales value.
    A single measure is used to calculate the difference between sales and target. The color is then determined by a formatting rule.
    Colors are directly assigned to the target and sales values in the data set.
    Separate measures are created to calculate the deficit (red) and surplus (blue) values.
    30s
  • Q4
    What is the purpose of the slicer in the target vs actual chart?
    To format the data labels.
    To add a legend to the chart.
    To differentiate between met and unmet targets.
    To allow users to filter the chart by year and see how targets were met or missed in each month of that year.
    30s
  • Q5
    How are custom tooltips created in the chart?
    It is not possible to create custom tooltips in Power BI.
    By using a separate measure to capture all the values and linking it to the chart.
    By adding data labels to the chart.
    By enabling a built-in tooltip option in Power BI.
    30s
  • Q6
    What are the three components that make up the bars in the target vs actual chart?
    Minimum of Sales Value and Target Value, Maximum of Sales Value and Target Value, Target Line
    Minimum Sales Value, Maximum Sales Value, Target Value
    Sales Variance, Target Variance, Average Sales Value
    Deficit, Surplus, Supporting Bar
    30s
  • Q7
    What visualization type is used to create the target vs actual chart?
    Line chart
    Line and stacked column chart
    Bar chart
    Stacked column chart
    30s
  • Q8
    How are the blue and red bars created in the chart?
    The blue bar is the target value and the red bar represents the actual sales value.
    A single measure is used to calculate the difference between sales and target. The color is then determined by a formatting rule.
    Separate measures are created to calculate the deficit (red) and surplus (blue) values.
    Colors are directly assigned to the target and sales values in the data set.
    30s
  • Q9
    What is the purpose of the slicer in the target vs actual chart?
    To format the data labels.
    To differentiate between met and unmet targets.
    To add a legend to the chart.
    To allow users to filter the chart by year and see how targets were met or missed in each month of that year.
    30s
  • Q10
    How are custom tooltips created in the chart?
    By using a separate measure to capture all the values and linking it to the chart.
    By adding data labels to the chart.
    It is not possible to create custom tooltips in Power BI.
    By enabling a built-in tooltip option in Power BI.
    30s

Teachers give this quiz to your class