Visual formatting options in Power BI - Dashboard Guide

Dashboard Mode - Visual formatting options

Dashboard Goal

This dashboard answers: How can we use visual formatting options in Power BI to make data easier to understand and more appealing?

Sample Data

Region	Product	Sales	Profit	Month
East	Chair	120	30	Jan
West	Table	200	50	Jan
East	Desk	150	40	Feb
West	Chair	180	45	Feb
East	Table	210	60	Mar
West	Desk	170	42	Mar

Dashboard Components

• KPI Card - Total Sales: Shows total sales with large font and green color for positive value.
  Formula: Total Sales = SUM(Sales)
  Result: 1030
• KPI Card - Total Profit: Shows total profit with large font and blue color.
  Formula: Total Profit = SUM(Profit)
  Result: 267
• Bar Chart - Sales by Region: Displays sales grouped by Region with custom colors (East = orange, West = purple).
  Formula: SUM(Sales) by Region
  Visual formatting: Data colors set, axis labels bold, gridlines light gray.
• Table - Detailed Sales Data: Shows Region, Product, Sales, Profit, and Month with alternating row colors for readability.
  Visual formatting: Header background dark gray with white text, rows alternate light gray and white.

Dashboard Layout

+----------------------+----------------------+
|   KPI: Total Sales   |   KPI: Total Profit   |
+----------------------+----------------------+
|                      Bar Chart: Sales by Region                      |
+---------------------------------------------------------------------+
|                      Table: Detailed Sales Data                     |
+---------------------------------------------------------------------+

Interactivity

Filters or slicers can be added for Region and Month. When a filter is applied:

• KPI cards update to show totals for the selected data.
• Bar chart updates to show sales by region for the filtered data.
• Table updates to show only rows matching the filter.

Self Check

If you add a filter for Month = Feb, which components update and what will they show?

• KPI Cards: Total Sales = 330 (150 + 180), Total Profit = 85 (40 + 45)
• Bar Chart: Shows sales by region for Feb: East = 150, West = 180
• Table: Shows only rows with Month = Feb (2 rows)

Key Result

A Power BI dashboard demonstrating visual formatting options with KPI cards, bar chart, and table using sales data.