How to Identify the Sales Table as a Fact Table in Power BI (Model View)

In Power BI, there’s no formal “fact table” label—but you can identify and treat a table as a fact table based on its role and structure. Here’s how to identify and set up the Sales table as the fact table in Model View:

✅ Step 1: Open Model View

1. In Power BI Desktop, click the Model icon on the left panel (looks like a table with relationships).
2. This opens the Model View, where all tables and their relationships are visible.

---

✅ Step 2: Understand What Makes a Fact Table

• Fact tables contain:
  • Numeric, measurable data (e.g., Units, Unit Cost, Unit Price)
  • Foreign keys that link to dimension tables (e.g., ProductID, CustomerID, Date, CampaignID, ManufacturerID)
• In your case, Sales is a perfect fact table because:
  • It records sales transactions
  • It references many other entities using IDs

---

✅ Step 3: Position & Organize Tables (Best Practice)

This is for visual clarity, not function:

1. Drag the Sales table to the center of the model canvas.
2. Position dimension tables (e.g., Product, Customer, Date, Campaign, Manufacturer) around it.
3. Create relationships by dragging:
   • Sales[ProductID] → Product[ProductID]
   • Sales[CustomerID] → Customer[CustomerID]
   • And so on…

---

✅ Step 4: Rename to Indicate Its Role (Optional)

Rename the table to Fact_Sales or just leave it as Sales, but you refer to it as a fact table because of its role.

---

✅ Step 5: Add Measures to Enhance It

Add DAX measures like:

DAXCopyEditTotal Sales = SUM(Sales[Unit Price])
Total Units = SUM(Sales[Units])
Total Cost = SUM(Sales[Unit Cost])
Profit = [Total Sales] - [Total Cost]

---

📌 Summary

In Power BI:

• You identify a fact table by its structure (metrics + foreign keys).
• You position it centrally and link dimension tables around it.
• You build measures on top of it for analysis.