👥 Total Users: – 🟢 Online Now: –
Home › Dashboard › Cost of Living Tracker
â›¶ Full Screen (No ads)

Inflation • Power BI

Cost of Living Tracker: What Is Really Getting More Expensive

✉ Get the PBIX file (free, just email us)

When the news says inflation is 3%, it hides the real story. Rent can climb 5% while gasoline falls, and the two average out into a number that matches nobody's budget. This dashboard breaks the headline into the categories that make up a household budget, so you can see which costs are rising, which are falling and how fast.

The data comes from the US Bureau of Labor Statistics consumer price index, delivered through FRED, the Federal Reserve Economic Data service. The dashboard is free to view here, and the Power BI file is free to download. You only need to send us an email.

What the dashboard shows

It is one tall page that you scroll from top to bottom. Everything responds to two controls at the top: a time period and a view.

The controls

  • Period: 1Y, 3Y, 5Y, 10Y or Max. It sets how far back the trend charts, the key insight and the purchasing-power card look.
  • View: switch the main chart between change vs year ago, price index and monthly change.

Six headline cards

The first row shows all-items inflation and five major categories: food, rent, energy, medical care and transportation. Each card has the current rate of change from a year ago, how much that rate moved since last month, and a small trend line. Rising prices are marked in warm colors and falling prices in green.

Key insight and purchasing power

A sentence written from the data tells you how much prices have risen since the start of your chosen period, which category is rising fastest and whether any category is falling. Beside it, a card shows what $100 from the start of the period buys today. If it shows $81, the same basket of goods now costs about 23% more.

Inflation by category

A ranked bar chart shows the change from a year ago for eight categories: food, rent, energy, medical care, transportation, apparel, recreation and education. It is the quickest way to see where prices are rising fastest.

How prices moved

The line chart compares all items with six major categories over your chosen period. In the index view, every line starts at 100, so you can see the total rise since the start and which categories pulled ahead.

The monthly heatmap

The heatmap shows the monthly price change for each category over the last 12 months. Warm cells are price rises, green cells are falls and gray cells are flat. Look for rows that stay warm month after month, such as rent, and rows that flip between warm and green, such as energy.

Housing, energy and food deep dives

Three panels split the biggest budget items in two:

  • Housing: rent of a primary residence vs owners' equivalent rent, which measures what homeowners would pay to rent their own home.
  • Energy: gasoline vs electricity, which often move in different directions.
  • Food: food at home (groceries) vs food away from home (restaurants).

Your personal inflation

Official inflation uses an average household. Yours is different. Pick a profile (Renter, Homeowner, Student or Retiree) and the dashboard weights each category by an example spending pattern, then compares your rate with the official one. Two charts show how the profile spends and which categories add the most to the rate.

About the profiles: the spending weights are illustrative examples chosen for this dashboard. They are not official statistics, so treat the personal rate as a way to see how different budgets feel inflation, not as a precise measurement of your own costs.

How to read the numbers

Change from a year ago vs monthly change

The year-over-year view smooths out noise and is the figure most people mean by "inflation". The monthly view reacts quickly, so it helps you spot a turning point, but it jumps around, especially for energy and apparel.

Why falling energy can hide a lot

Energy prices swing sharply. When gasoline drops, the headline rate can look calmer even while rent, food and medical costs keep climbing. That is why the dashboard shows the categories side by side.

Rent vs owners' equivalent rent

Housing is the largest cost for most households, and the two measures can differ. Rent tracks what tenants pay for new and renewed leases, while owners' equivalent rent estimates the implicit rent of owned homes and tends to move more smoothly.

Where the data comes from

Every series is a seasonally adjusted consumer price index from the Bureau of Labor Statistics, pulled from FRED. The BLS publishes them monthly, so the dashboard changes once a month, shortly after each release.

Category FRED series Update frequency
All itemsCPIAUCSLMonthly
FoodCPIUFDSLMonthly
Rent of primary residenceCUSR0000SEHAMonthly
EnergyCPIENGSLMonthly
Medical careCPIMEDSLMonthly
TransportationCPITRNSLMonthly
ApparelCPIAPPSLMonthly
RecreationCPIRECSLMonthly
Education and communicationCUSR0000SAEMonthly
Owners' equivalent rentCUSR0000SEHCMonthly
GasolineCUSR0000SETB01Monthly
ElectricityCUSR0000SEHF01Monthly
Food at homeCUSR0000SAF11Monthly
Food away from homeCUSR0000SEFVMonthly

The dashboard loads data from 2010 onward. "Max" in the period selector means everything since then.

Download the PBIX file for free

The dashboard file is not a premium feature. To get it, send an email to contact@docynx.com and we will send you the .pbix file. You can open it in the free Power BI Desktop, add your own categories or use it as a learning project.

About the FRED API key

The dashboard refreshes by calling the FRED API, which needs an API key. You have two options:

  • Use the key already in the file. The PBIX comes with a working key, so it refreshes as soon as you open it. Because many people may share it, it can run into FRED's rate limits.
  • Use your own key. FRED API keys are free. Create an account on the FRED website, request a key, and replace the key value inside the Cpi query in Power Query. Your own key gives you your own usage limit.

Either way, the data comes straight from FRED, so no manual downloads are needed.

A note on interpretation: This dashboard is for learning and general information. It is not financial advice. Price indexes are revised and reflect an average household, so they will not match every person's experience.

Conclusion

Inflation is not one number. It is a set of different stories: housing that keeps climbing, energy that swings and groceries that sit in between. Breaking the headline into categories makes it clear where your money is going, and the personal view shows why two people can feel very different inflation in the same month. If you build your own version, start with the FRED series above and add the categories that matter to the people you are building it for.

Explore Free Online PDF & Image Tools by Docynx