I built an interactive Power BI dashboard analyzing Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs) registered in Washington State using publicly available government data.
The report combines geographic analysis, CAFV incentive eligibility, battery range trends, manufacturer market share, and interactive tooltip drilldowns to create a dynamic EV market overview.
Key Features:
I created multiple custom measures for both BEV and PHEV analysis, including:
- Total registered vehicles;
- Average electric range;
- Average model year;
- Top manufacturers;
- Most popular models;
- CAFV eligibility %;
- Tooltip-specific dynamic measures;
- Conditional “No data available” logic;
- Dynamic display formatting (e.g., 200 miles, N/A, percentages).
Examples of implemented logic:
- Filtering BEV vs PHEV datasets separately.
- Ignoring blank/zero electric range values.
- Handling unavailable CAFV eligibility data.
- Dynamic tooltip context filtering.
Interactive Tooltip Pages:
I designed custom tooltip report pages that appear on mouse hover, including:
✅Geographic tooltip cards;
✅Manufacturer insights by region;
✅Vehicle registration evolution by model year;
✅Dynamic average range metrics;
✅Context-aware CAFV statistics.
This creates a much more interactive and exploratory user experience compared to standard Power BI visuals.
Automated Daily Data Refresh:
The report uses a live public government dataset connected directly from:
https://catalog.data.gov/dataset/electric-vehicle-population-data.
Since the source is connected through a web data link, the dataset can be refreshed automatically whenever new vehicle registration data becomes available. This allows the dashboard to stay current without manual file replacement.
Skills Practiced:
- Microsoft Power BI;
- DAX;
- Data Modeling;
- Interactive Tooltips;
- Conditional Formatting;
- Geospatial Visualization;
- Time-Series Analysis;
- Dynamic Measures;
- UI/UX Dashboard Design;
- Web Data Integration;
- Automated Refresh Logic.
eyJrIjoiMTA5ZGY0MmQtOWM0Yy00NGI3LTliMGItNmJjODkzZWIzZTQ5IiwidCI6IjY1NWVhZjVhLTBhMTctNDEzOS05NzU5LTFlMDIzMTRkMDJhYiIsImMiOjZ9
