Microsoft Power BI Data Analyst — Question 62

You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products.

You need to display the total sales by quarter categorized by product. The visual must display trends in both total sales and individual product sales.

Which type of visual should you use?

Answer options

• A. area chart
• B. clustered column chart
• C. stacked area chart
• D. line chart

Correct answer: C

Explanation

The stacked area chart is the correct choice as it allows for the visualization of both total sales and the breakdown by product, making trends easy to identify. The area chart does not differentiate between products, while the clustered column chart does not effectively show cumulative totals. The line chart can represent trends but does not accommodate individual product categorization as well as the stacked area chart.