When we use the term Trend Data, we are talking about displaying and comparing values over time. Power BI gives us many options in this category, each with their own focus. The idea for each of the visuals, though, is to draw attention to the total value across a length of time. Let's create a new report page and call it Trend Data, and dive right in to see what the differences are between the following options:
- Line and Area Charts
- Combo Charts
- Ribbon Charts
- Waterfall and Funnel Charts
The Line chart is the most basic of our options when it comes to looking at data over time. The Area chart and Stacked Area chart are based on the line chart; the difference is that the area between the axis and the line is filled in with colors to show volume. Because of this, we will focus on the Line chart for our example. Since we have a very nice Date hierarchy, we will use this alongside a couple of measures to see trending.
Let's look at, setting up the visual...