Power BI for Beginners: Two Steps to Your First Dashboard

If you have been building the same report in Excel for years, Power BI looks like it ought to be easy. You already have the data. You already know what the chart is supposed to say. Then you open the program for the first time and there are five panes, a ribbon full of unfamiliar words, something called Power Query, something else called DAX — and you quietly close it again.

I teach Power BI for beginners more often than almost anything else these days, and here is what I have noticed: people are almost never stuck on the hard parts. They are stuck in the first twenty minutes. Loading a file. Getting one number to show up correctly. Making the months stop sorting alphabetically.

So here are the two things I would show you if you were sitting next to me. Neither takes longer than ten minutes, and together they get you from a spreadsheet to something you can show your boss.

Power BI for Beginners, Step One: Click Transform Data, Not Load

In Power BI Desktop, go to Home → Get data → Excel workbook, pick your file, and tick the sheet or table you want. Now the important part. At the bottom of that Navigator window are two buttons: Load and Transform Data. Almost everyone clicks Load. Click Transform Data instead.

That drops you into Power Query, which is where you clean the data once so you never have to clean it again. Four moves cover most real spreadsheets:

• Home → Remove Rows → Remove Top Rows to strip out a company title, a blank line, a “Printed on” stamp — anything sitting above your real header row.
• Home → Use First Row as Headers, so your columns are named Region and Amount instead of Column1 and Column2.
• Click the little icon to the left of each column name and set the data type deliberately: Date, Whole Number, Decimal Number, Text.
• Select the columns you actually need, right-click, and choose Remove Other Columns. A narrow model is a fast model.

Every click you make gets recorded in the Applied Steps list on the right. That list is the whole point. Next month, when somebody hands you the same export with new numbers in it, you drop the new file in place and hit Refresh — and all four steps run again by themselves. That is the hour you get back.

The gotcha: watch your date column. If Excel stored those dates as text, Power Query types the column as Text and nothing complains — then sorting, month grouping and any date math behave strangely for reasons you cannot see. Set that column to Date here, and if it throws errors, your source data has junk in it you want to find now rather than in the meeting. Then click Close & Apply.

Step Two: One Measure, One Chart, One Slicer

Now build the smallest useful dashboard there is.

Write a measure instead of dragging a number. It is tempting to drag Amount onto the canvas and let Power BI sum it for you. Don’t. Go to Home → New measure and type:

Total Sales = SUM(Sales[Amount])

With the measure selected, use Measure tools on the ribbon to set the format to currency with zero decimals — formatting done once, forever. Drag Total Sales onto a Card visual and you have your headline number. Reuse it in every chart on the page and it stays consistent, which is exactly what you do not get from dragging raw columns around.

Add one chart. Click a blank spot, choose Stacked column chart, put your month field on the X-axis and Total Sales in values.

Add one slicer. Click a blank spot again, choose Slicer, and drop Region into it. Click a region and the card and the chart both filter together. That interaction is the thing that makes people in class sit up, and it took you about four clicks.

The gotcha, and it catches everyone: your months will sort alphabetically. April, August, December, February. The fix is a numeric month column (1 through 12) in your table. Select the month name column, go to Column tools → Sort by column, and choose the month number column. Power BI now knows the real order. One thing to file away for later: proper date math, like year-to-date or same period last year, wants a dedicated date table rather than the date column sitting in your sales data.

Plenty more on the calendar

I am running a live session, Mastering Power BI: A Comprehensive Guide for Beginners, on Friday, November 6. It walks through exactly this path at a comfortable pace — getting data in and cleaned with Power Query, building the model, writing your first measures, and laying out a report that other people can read without you standing next to them.

The full current schedule lives on the front page of PCWebinars.com, with new dates going up as they are confirmed. Come to this one, or browse the list and find the topic that is costing you the most time right now.

About your trainer

I’m Tom Fragale. I have been a computer trainer and consultant for more than 30 years, and I have taught well over 30,000 people how to get more out of the software they already own — Excel, Access, Power BI, Word, Outlook, and now the AI tools that sit on top of all of it: Claude, ChatGPT, and Microsoft Copilot. My background is applied, not theoretical. Alongside the teaching, I build real databases and reporting systems for clients in Excel, Access, and Power BI, so the examples I bring to class are the problems I ran into last week, not textbook exercises. I also publish free tutorials on YouTube and longer courses online.

If this was useful, there is a lot more of it waiting for you at PCWebinars.com.