Microsoft Power BI Data Analyst — Question 20

You need to create a visual that compares profit across 10 product categories fora selected quarter.

What is the best visual to use to achieve the goal?

Answer options

• A. an area chart
• B. a funnel chart
• C. a clustered bar chart
• D. a line chart

Correct answer: C

Explanation

A clustered bar chart is the best choice for comparing profits across multiple product categories, as it allows for easy side-by-side comparison of the values. An area chart is less effective for direct comparisons, a funnel chart is typically used for depicting stages in a process, and a line chart is better suited for showing trends over time rather than categorical comparisons.