9. Build the Parking Inspection BI Report - Part 1

In this Power Up Challenge walkthrough, we bring your *Parking Inspection App* to life visually by kicking off our *Power BI reporting* integration. In Part 1, we lay the foundation for the entire report, including the *navigation*, *background styling*, *date logic*, and *core data model* setup.

We also build out the *Home Page*, start up the Filter and Review pages, create a dynamic *DAX-based Date Table*, and prepare everything for full filtering and cross-page interaction in Part 2.

---

### 🎯 **In Part 9, we:**

* Create and style *Power BI pages* with consistent branded backgrounds
* Build a modern *navigation bar* using buttons to move between Home and Review & Filters page.
* Import and transform *Dataverse tables* (ParkingInspections & Vehicles)
* Create a complete *DAX-based Date Table* for time intelligence
* Define *model relationships* between ParkingInspectionInfo, VehicleInfo, and dimDate
* Add a `MyMeasures` table to hold KPIs like total inspections, valid requests, and percentages
* Tweak visuals for layout, sorting, and filter compatibility
* Prepare the stage for *Part 2* – where we’ll finalize slicers and visual breakdowns

---

### 🔧 *Key DAX Used*

```dax
ParkingInspectionsInfo
InspectionDate =
DATE(
YEAR(Parkinginspectioninfo[InspectionDateTime]),
MONTH(parkinginspectioninfo[InspectionDateTime]),
DAY(parkinginspectioninfo[InspectionDateTime])
)

isRequested =
IF(
NOT(ISBLANK(parkinginspectioninfo[ParkingRequestInfo])),
TRUE(), -- Has associated request, thus permitted
FALSE() -- No request, thus not permitted
)

My Measures
Total Inspections =
COUNTROWS(parkinginspectioninfo)

Total Requests =
CALCULATE(
COUNTROWS(parkinginspectioninfo),
parkinginspectioninfo[isRequested] = TRUE()
)

% Inspections with Valid Parking Requests =
DIVIDE(
[Total Requests],
[Total Inspections],
0
)
```

---

### *Power Up Challenge 2025/26 Walkthrough Series – Parking Challenge*

https://youtu.be/PxUac6bR20E

https://youtu.be/yf7kXXXwkC4
https://youtu.be/ZUpNUtnvI6Y
https://youtu.be/j1SpSY1gNuU
https://youtu.be/rPWNC0j44mg
https://youtu.be/UqstDSaGjhM
https://youtu.be/1XB_uk6FBpI
https://youtu.be/jtBn5lQQ_QY
https://youtu.be/xz1ULz2iuns
https://youtu.be/o8hWQLqPNFU - (You are here)
https://youtu.be/EgRzPJqRjxo
*MVP Complete.*
---

💡 *Join the challenge and build your Parking Inspection App from start to finish!*
Power Up Challenge 2025/26 – Let’s keep building!

Видео 9. Build the Parking Inspection BI Report - Part 1 канала T.O@PowerAppTutorials