In this exercise, we will walk through creating a Sales Summary visuals in Power BI. You will learn how to load data into Power BI, create measures for Total Sales and Profit, and design a clustered column chart to visualize sales by region.
This hands-on task is perfect for beginners looking to understand the basics of data visualization and measure creation in Power BI.
Tasks:
- Load the dataset into Power BI.
- Create a measure to calculate Total Sales.
- Create a measure to calculate Profit.
- Create a clustered column chart to show Sales by Region.
Solution:
Download Dataset: Sales Dataset
Step-1: Load the dataset into Power BI.
Go to the Home tab > Click on Get Data > and select Text/CSV.
Step-2: After selecting the file, you can see the data preview. Click on Load.
Step-3: Create a measure to calculate Total Profit & Total Sales.
Right-click on the dataset and select “New Measure.”
Total Sales = SUM(Sales[Sales])
Profit = SUM(Sales[Sales]) - SUM(Sales[Cost])
Now add two card visuals to the report page and drag both measures into the card visuals.
Step-4: Create a clustered column chart to show Sales by Region.
Add a clustered column chart to the report page, then drag the Region column to the X-axis and the Total Sales measure to Y-axis.
I hope you enjoyed this Power BI exercise.
