Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are a data analyst for a retail company. A sales manager has a Power BI report containing a line chart that displays total sales by month over the past three years. The manager wants to project sales for the next six months to aid in inventory planning. Crucially, they also need to visualize the potential best-case and worst-case scenarios for this projection. Which feature from the Analytics pane should you use to fulfill this specific request?

  • Add a Trend line and set its style to dashed to show the likely direction of sales.

  • Use the Forecast feature and adjust the Confidence interval to display the upper and lower bounds.

  • Enable Error bars and configure the upper and lower bounds based on a fixed percentage of sales.

  • Add separate Min and Max lines to show the historical minimum and maximum sales on the chart.

Microsoft Power BI Data Analyst
Visualize and Analyze the Data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot