Building Basic Visuals in Power BI

Hello! Welcome to the next step in your Power BI journey.

In our last lesson, we built the "brain" of our report by creating a data model. You learned how to connect different tables using relationships, which is the foundation for creating insightful analysis. Now that we have a solid structure, it's time to build the "face" of our report—the visualizations that bring the data to life.

Today's lesson focuses on exactly that. Our goal is to create basic visualizations in Power BI, including bar charts, line charts, and tables. We'll move into the Report view of Power BI Desktop and learn how to transform the raw data from your tables into clear, meaningful charts.

1. Navigating the Report View

Let's begin by familiarizing ourselves with the main workspace for building visuals. When you open Power BI Desktop, you land in the Report view. It has three key areas we'll be using constantly:

1. The Canvas: This is the large, blank area in the middle where you'll build and arrange your visuals.
2. The Visualizations Pane: On the right, this pane contains a gallery of all the available chart types (bar, line, pie, etc.). When you select a visual on your canvas, this pane also shows the "buckets" (like Axis, Values, Legend) that you'll drag your data into.
3. The Fields Pane: To the far right, this pane lists all the tables and columns in your data model. This is where you'll get the data to populate your visuals.

To see these panes in action and get an introduction to why visualizations are so crucial, let's start with a short video.

2. Starting Simple: Creating Tables and Matrices

The most fundamental way to display data is in a table. While not as flashy as a chart, tables are invaluable for looking up specific values or showing detailed information. A financial analyst might use a table to see a list of all transactions for a specific stock.

Power BI offers two main table-like visuals:

• Table: A simple, flat grid of rows and columns.
• Matrix: A more advanced table that allows you to group and summarize data in both rows and columns, much like a PivotTable in Excel. You can even create hierarchies to drill down into your data (e.g., Year > Quarter > Month).

Let's see how to create both.

The process is straightforward:

1. Click the Table or Matrix icon in the Visualizations pane.
2. A blank visual appears on your canvas.
3. With the visual selected, drag the data fields you want to display from the Fields pane into the appropriate bucket (e.g., 'Values' for a table, or 'Rows', 'Columns', and 'Values' for a matrix).

3. Comparing Categories: Bar and Column Charts

Bar and column charts are staples of data visualization. They are perfect for comparing a numerical value across different categories. For financial analysis, this could mean:

• Comparing sales revenue across different countries.
• Visualizing portfolio allocation by asset class (Stocks, Bonds, etc.).
• Ranking companies by market capitalization within a sector.

The process is very similar to creating a table, but you'll use different buckets.

The following video walks you through creating and formatting a clustered column chart.

For a text-based guide that you can follow step-by-step, the DataCamp article "Introduction to Power BI Visuals" is an excellent resource.

4. Tracking Trends Over Time: Line Charts

Line charts are the go-to visual for tracking trends. For anyone interested in financial markets, this is one of the most important chart types you will use. It's perfect for showing:

• A stock's price movement over the last year.
• Quarterly earnings of a company.
• Changes in a market index like the NIFTY 50 or S&P 500.

The key to a line chart is having a date or time field on the x-axis.

Again, you can refer to the DataCamp article for a step-by-step text guide on creating a line chart. Review the "Line charts" section in the same resource (LINK) you looked at earlier.

Conclusion

Congratulations! You've successfully moved from a structured data model to creating the three most fundamental types of visualizations in Power BI. This is a huge milestone. You now have the skills to represent your data as detailed tables, categorical comparisons, and time-series trends.

Key Takeaways:

• Visuals are built in the Report view by adding a visual to the Canvas and populating it with data from the Fields pane.
• Tables and Matrices are used to display detailed, grid-like data. A Matrix is like an Excel PivotTable.
• Bar/Column charts are best for comparing numerical values across different categories.
• Line charts are essential for visualizing trends over a period of time.
• The Axis, Values, and Legend buckets are the primary controls for defining what your chart displays.

In this lesson, you may have noticed the Format pane (the paintbrush icon). This is where you control the look and feel of your visuals—colors, titles, font sizes, and more. While we briefly saw it in action, our next lesson will be dedicated entirely to formatting visualizations. You'll learn how to take these basic charts and style them to create a polished, professional, and consistent report that effectively tells a story with your data.