Creating Scatter, Waterfall, and Funnel Charts - Training

Creating Scatter, Waterfall, and Funnel Charts - Training

Scatter, waterfall, and funnel charts are powerful visualizations that can provide valuable insights and comparisons between different measures. In this article, we will explore how to create these charts and the various formatting options available.

To start with, let's look at scatter charts. Scatter charts allow us to compare two different measures, such as unit sales versus revenue. By adding a legend field, we can apply color coding to the bubbles based on the value of the field. Additionally, we can modify the size of the bubble by adding a field to the size cube. Scatter charts also offer visual formatting options, such as enabling a border around each colored bubble and alternating individual labels. Moreover, we can change the data colors for other types of charts.

If you only see one bubble in the scatter chart, don't worry. Power BI is aggregating the data by default. To display more bubbles, add a category to the details cube in the Visualizations pane.

Moving on to waterfall charts. These charts are commonly used to show changes that occur over time in a specific value. Waterfall charts have two cube options: Category and Y-Axis. To create a waterfall chart, drag a time-based field (such as Year) to the Category cube, and drag the value you want to track to the Y-Axis cube.

Lastly, let's discuss funnel charts. Funnel charts are often used to visualize changes that take place during a specific process, such as a sales pipeline or website retention efforts. Funnel charts can be segmented and customized to suit your needs.

Now that we have explored the different types of charts, let's move on to matrices and tables. Matrices and tables are great for displaying numerical information. If you have numerical data in a table, such as a revenue report, Power BI automatically provides a total sum at the bottom. You can manually sort each column by selecting the column header and changing the order between ascending and descending.

The order of fields in the Values cube determines the order in which they appear in the table. If you want to change the order, simply rearrange the fields in the Values cube in the Visualizations pane.

A matrix is similar to a table but has different category headers in rows and columns. There are many cosmetic options available for matrices, such as automatically resizing column widths, alternating row and column totals, and setting custom colors.

In conclusion, scatter, waterfall, and funnel charts are powerful visualization tools that can provide valuable insights into your data. By understanding how to create and format these charts, you can effectively communicate your data findings to others. Here are three actionable pieces of advice to keep in mind:

1. Experiment with different formatting options: Play around with the formatting options available for scatter, waterfall, and funnel charts. This will allow you to customize the charts to best suit your data and presentation needs.

2. Don't be afraid to segment and customize: Take advantage of the segmentation and customization options available for waterfall and funnel charts. This will allow you to highlight specific aspects of your data and make it more visually appealing.

3. Utilize matrices and tables for numerical data: Matrices and tables are great options for displaying numerical information. Take advantage of the automatic total sum feature and explore the various cosmetic options available to enhance the readability of your data.

In summary, scatter, waterfall, and funnel charts, along with matrices and tables, are powerful tools in Power BI that can help you visualize and analyze your data effectively. By understanding how to create and format these charts, you can present your data in a visually appealing and informative manner. So, go ahead and explore these charts in Power BI to unlock valuable insights from your data.