Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Easy
Question 12
You have a dataset containing the number of new subscribers and cancellations per month for a subscription-based service.
You want to create a visualization to compare the number of new subscribers and cancellations on a monthly basis (showing trends over time).
Which type of visualization would be most effective?
-
A
Area chart
-
B
Line chart
-
C
Clustered bar chart
-
D
Stacked bar chart
Reveal correct answer
Correct answer: B
Explanation
When selecting a visualization in Power BI, it is essential to choose a chart type that clearly communicates the insights and allows for an easy comparison between data points.
Best Visualization for This Scenario: Line Chart
A line chart is the most effective visualization for comparing the number of new subscribers and cancellations on a monthly basis. It allows for a clear representation of trends and patterns over time, making it easy to see the relationship between the two variables.
Learn more about Clustered Bar Charts in Power BI.Line Charts in Power BI.
Alternative Visuals and Why They Are Less Effective
Clustered Bar Charts: A clustered bar chart is not the most effective choice for comparing the number of new subscribers and cancellations on a monthly basis. This type of chart is more suitable for comparing multiple categories within each month rather than tracking changes over time. See Clustered Bar Charts in Power BI.
Stacked Bar Charts: Useful for total comparisons, but not effective for comparing individual components. Read about Stacked Charts in Power BI.
Area Charts: Suitable for cumulative data visualization, but not great for side-by-side metric comparisons. Explore Area Charts in Power BI.
By using a Clustered Bar Chart, you can effectively compare the number of new subscribers and cancellations per month, making it the best choice for this analysis.
A. An area chart is not the most effective choice for comparing the number of new subscribers and cancellations on a monthly basis. While it can show the overall trend of the data, it may not provide a clear comparison between the two variables on a monthly basis as effectively as a line chart would.
B. A line chart is the most effective visualization for comparing the number of new subscribers and cancellations on a monthly basis. It allows for a clear representation of trends and patterns over time, making it easy to see the relationship between the two variables.
C. A clustered bar chart is not the most effective choice for comparing the number of new subscribers and cancellations on a monthly basis. This type of chart is more suitable for comparing multiple categories within each month rather than tracking changes over time.
D. A stacked bar chart is not the most effective choice for comparing the number of new subscribers and cancellations on a monthly basis. This type of chart is more suitable for showing the total quantity and the composition of each month's data, rather than comparing two separate variables over time.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
