Subscriber only lesson.
Sign up to this course to view this lesson.
About this lesson
Line charts are a great way to show trends over time, and we'll explore doing so here.
Working with Line charts in Power BI.
When to use
Line charts are useful for showing trends in your data.
Line charts and area charts are very similar, with the latter essentially just being a line chart with the lower area filled in. (The stacked area chart is obviously an exception to this.)
Types of Line Charts
- Line Chart
- Area Chart
- Stacked Area Chart
- Drag your Field into the Axis area. The unique items in this field will be used for the primary axis
- The alternate axis is calculated automatically
- The measure(s) to visualize should be dragged into the Value area
- Legends and tooltips can also be configured
- Dragging multiple fields into the Axis area will activate Drill Down
- Dragging multiple fields into the Value area will add another line
- Visual formatting can be done via the fields under the paint roller in the Visualizations area
- Trend lines can be found under the magnifying glass icon in the Visualizations area
Hints & tips
Common Modifications for Line charts
- Rename the Legend and force it to bottom
- Provide a custom title for the chart
- Change the y-Axis display units
- Change the line (or fill) colors
- Turn on Data Labels and customize the series (each series can be controlled separately)
Lesson notes are only available for subscribers.