Visualizations

Common Visuals in Power BI

Description: Visualizations (or "visuals") are the heart of Power BI. They are the graphical representations of your data that tell a story. Power BI offers a vast library of built-in visuals, ranging from simple tables to complex maps, each designed to answer specific business questions.

Why: Choosing the right visual is critical for effective data storytelling. If you use a Pie chart for 50 different categories, the data becomes unreadable. Beginners should focus on mastering the "Core Five" (Cards, Bars, Lines, Tables, and Slicers) to build clear and professional dashboards.

The Visualization Library

Power BI Desktop provides a "Visualizations Pane" on the right side of the screen where you can select your desired chart type:

Visual Type	Best Used For...
Card	Highlighting a single, critical number (e.g., Total Revenue or Total Profit).
Bar / Column Chart	Comparing values across different categories (e.g., Sales by Product or Region).
Line / Area Chart	Showing trends over time (e.g., Monthly Sales Growth).
Matrix / Table	Displaying detailed data in rows and columns. The Matrix allows for "drill-down" capabilities similar to an Excel Pivot Table.
Slicer	An interactive filter that allows users to pick a specific Year, Region, or Category to filter the entire report.

Example: Building a Sales Dashboard

A standard beginner layout includes:

Cards: One for Total Sales and one for Total Orders at the top.
Line Chart: In the center, showing Sales Amount by Month.
Bar Chart: On the side, showing Profit by Product Category.
Slicer: A dropdown list for Region so users can filter the whole page.

Conditional Formatting

Description: Conditional formatting allows you to change the appearance of your data—such as background colors, font colors, or icons—based on the values in your dataset. It is a powerful way to make your reports "talk" to the user without them having to read every single number.

Why: In a large table of data, it is hard to find the "trouble spots" or "success stories." Conditional formatting uses color to draw the user’s eye instantly to high or low values, outliers, or specific targets.

Types of Formatting Styles

You can apply formatting to table cells, matrix values, or even the bars in a chart:

Style	How it Works
Gradient (Color Scales)	Lower values are one color (e.g., Light Red) and higher values are another (e.g., Dark Green).
Rules	Specific logic, such as: "If value is > 1000, make background Blue."
Icons	Adds visual cues like green checkmarks, yellow warning triangles, or red circles next to values.

Example: The Profit Signal

Visualizing Profitability:

In a Sales table, you can set a Rule for the "Profit" column: If the profit is less than 0, set the font color to Red. If the profit is greater than or equal to 0, set the font color to Green. This helps a manager instantly identify which products are losing money.

Key Notes

Accessibility: Be careful with red/green combinations for color-blind users. Using Icons in addition to color is a great way to ensure everyone can understand the report.
Data Bars: Inside a table, you can enable "Data Bars." This puts a small horizontal bar inside the cell, essentially turning your table into a mini-bar chart.
Consistency: Keep your color logic consistent throughout the report. If "Green" means "Good" on Page 1, don't use it for something negative on Page 2.

🏋️ Test Yourself With Exercises

Take our quiz on Visualizations to test your knowledge.

Browse Quizzes »

Previous Next