Microsoft Certified: Fabric Analytics Engineer AssociateExplore and analyze data (15-20%)Medium
A BI developer is creating a Power BI report using data from a Lakehouse in Microsoft Fabric. They need to visualize the weekly sales trends over the last year. The data is stored in a Delta table. Which type of visual is most appropriate for showing trends over time?
- APie chart
- BScatter plot
- CBar chart
- DLine chart
Show answer & explanationAnswer & explanation
Correct answer: D. Line chart
A line chart is ideal for displaying trends over time because it connects data points with lines, making it easy to see the direction and magnitude of changes over a continuous period.
Why the other options are wrong
- A. A pie chart shows proportions of a whole, not trends over time.
- B. A scatter plot shows the relationship between two numerical variables, not typically a single trend over time.
- C. A bar chart is best for comparing discrete categories or values at specific points, not continuous trends.
Line Chart Use Case
A line chart is a type of chart that displays information as a series of data points called 'markers' connected by straight line segments. It is primarily used to visualize trends over time.
- Excellent for showing continuous data.
- Clearly illustrates trends, acceleration, deceleration, and volatility.
- Time series data is a primary use case.
Memory trick: Lines for time, Bars for categories, Pies for parts.