BAR CHART & COLUMN CHART(POWER BI)

SUM OF SALES BY MONTH & SUM OF STORE SALES BY STORE ID:

Power BI is a data visualization tool used to analyze data and create useful charts. In this blog, we create two charts to understand sales data.

Step 1: Import Data

1. Open Power BI Desktop.
2. Click Home.
3. Click Get Data.
4. Select CSV.
5. Choose your CSV file.
6. Click Open.
7. Select the required table. 8.Click Load.

Step 2: Create Sum of Sales by Month
Chart Type: Bar Chart

1.Select the Bar Chart from the Visualizations pane.
2.Drag Month to the category/Y-axis.
3.Drag Sales to the value/X-axis.
4.Power BI calculates the Sum of Sales automatically.
5.Set the title as “Sum of Sales by Month.

This chart shows the sales amount for each month. It helps us easily compare monthly sales.

Step 3: Create Sum of Store Sales by Store ID
Chart Type: Column Chart

1. Select the Column Chart from the Visualizations pane.
2. Drag Store ID to the X-axis.
3. Drag Store Sales to the Y-axis.
4. Power BI calculates the Sum of Store Sales automatically.
5. Set the title as “Sum of Store Sales by Store ID.

This chart shows the sales performance of each store. A taller column means higher sales.

Step 4: Understand the Charts

• Sum of Sales by Month → Helps to understand monthly sales.
• Sum of Store Sales by Store ID → Helps to understand store-wise sales.
• Both charts make the sales data easier to understand.

Conclusion
Power BI makes it easy to convert raw data into visual information. By using a Bar Chart and a Column Chart, we can quickly analyze monthly sales and store-wise sales.

Data Import → Create Bar Chart → Create Column Chart → Analyze Sales