How to Create a Simple Dashboard in Power BI with AI

Building a dashboard in Power BI used to feel like a job reserved for a data analyst. But now, with powerful AI features built directly into the platform, anyone can turn a simple spreadsheet into an insightful, interactive report without mastering complex formulas. This article will walk you through creating your first dashboard step-by-step using Power BI's AI tools to do most of the heavy lifting.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, What Exactly is a Power BI Dashboard?

Think of a Power BI dashboard as a single page, often called a canvas, that gives you a high-level view of your most important metrics. It uses visualizations like charts, gauges, and maps to tell a story at a glance. In Power BI, you technically build your visuals on a report page first. A report can have multiple pages and is designed for deeper, interactive analysis. A dashboard is a collection of the most critical visuals pinned from one or more reports, providing a consolidated summary.

The great news is that Power BI’s AI features dramatically shorten the path from data to dashboard. Tools like Q&A can create visuals for you based on plain-English questions, while others can automatically summarize what your data is saying. The result? You spend less time wrestling with menus and more time understanding your business.

Step 1: Get Your Data Ready for Analysis

Before you can build anything, you need some data. The most powerful AI in the world can't help if your source data is messy. For this tutorial, we'll use a simple sales spreadsheet, which is a common starting point for many businesses.

Your data doesn’t need to be massive, just organized. A good structure is a simple table with clearly labeled columns (headers) and rows of data underneath. For example, your Excel or Google Sheet might look something like this:

Example Sales Data:

• OrderDate: The date the sale was made (e.g., 01/15/2024)
• ProductName: The name of the product sold (e.g., Premium Widget)
• Category: The product category (e.g., Electronics)
• SalesAmount: The total value of the sale (e.g., 1500)
• Region: The sales region (e.g., North, South, West)

Once your data is cleaned up and saved, it's time to connect it to Power BI.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Connect Your Data Source:

1. Open Power BI Desktop. If you don't have it, you can download it for free from Microsoft.
2. On the Home ribbon, click on "Get Data." A window will appear with dozens of data source options.
3. Since we are using a spreadsheet, select "Excel workbook" (or "Google Sheets" if you are using that, which may require a connector) and click "Connect."
4. Navigate to your saved file and select it.
5. Power BI will show a preview of the tables in your file. Check the box next to your sales data table and click "Load."

Power BI will now load your data. You'll see the column headers appear in the "Data" pane on the right-hand side of your screen. Now you’re ready to start building.

Step 2: Let AI Build Your Visuals

This is where the magic happens. Instead of manually dragging fields and picking chart types, we’re going to ask Power BI’s AI to do the work. We'll explore three key features: the Q&A visual for asking questions, Smart Narratives for auto-generated summaries, and the Decomposition Tree for drilling down into the "why" behind your numbers.

1. Ask Questions with the Q&A Visual

The Q&A (Question & Answer) feature is one of the most powerful and intuitive AI tools in Power BI. It allows you to create visuals just by typing what you want to see in plain English.

How to use The Q&A Visual:

• In the Visualizations pane on the right, find and double-click the Q&A icon. A chat box will appear on your report canvas.
• Just start typing a question about your data. Power BI will understand your column names (like 'SalesAmount' and 'Region') and suggest answers as you type.

Example Prompts for Our Sales Data:

• Try typing: total sales amount – It will instantly display a card with the total sum.
• Now try: total sales by category as a donut chart – It will generate a properly formatted donut chart showing the sales breakdown.
• Ask something more specific: top 5 product names by sales amount – It will create a bar chart showing your best-selling products.
• You can even ask for maps: total sales amount by region on a map – It will generate a map visual with bubbles representing sales totals in each region.

Once you get a visual you like, you can convert it into a standard visual on your report page. To do this, click the icon on the top right of the Q&A box that looks like a chart with an arrow. This locks in the visual, and now you can resize and reposition it just like any other chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Explain Your Data with Smart Narratives

Finding an interesting spike or dip in your data is one thing, explaining why it happened is another. The Smart Narrative visual uses AI to automatically generate a text summary of the key insights from your visuals or your entire report page.

How to use Smart Narratives:

• First, make sure no visuals on your report page are selected by clicking on some empty canvas space.
• In the Visualizations pane, click on the Smart Narrative icon.
• Power BI will analyze all the visuals on the page and generate a paragraph summarizing the most significant findings. It might say something like, “At $5,500, sales are highest in the 'West' region, accounting for 45% of total sales. The 'Electronics' category drove the majority of this performance.”

This is extremely useful for adding context to your dashboard. Instead of just showing charts, you give your audience clear, readable highlights without writing a single word yourself.

3. Find the 'Why' with a Decomposition Tree

The Decomposition Tree is an AI-powered visual that helps you perform root cause analysis. It allows you to break down or "decompose" a metric by different categories to see which factors contribute the most.

How to use the Decomposition Tree:

• In the Visualizations pane, find and click the Decomposition Tree icon.
• In the "Fields" area for that visual, drag SalesAmount to the "Analyze" box. This is the metric we want to explore.
• Next, drag fields you want to use for the analysis into the "Explain by" box. For our example, add Region, Category, and ProductName.
• The visual will appear with your total SalesAmount and a small '+' sign next to it. Click the '+' and an AI-powered menu will ask how you want to break down the metric. You can choose "High value" or "Low value" to let the AI guide you to the most significant factor, or select one of the fields directly, such as 'Region'.

By clicking through the branches, you can drill down layer by layer. For example, you might see that the 'West' region has the highest sales, and by clicking on 'West', you can then see which product category performed best within that region. It’s an interactive way to let AI guide your data exploration.

Step 3: Assemble Your Report and Pin It to a Dashboard

At this point, you should have several AI-generated visuals on your report canvas: a bar chart from a Q&A prompt, a map, a smart narrative summary, and perhaps a decomposition tree for exploration. Now it's time to arrange them into a clean report and pin the most important elements to a dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Arranging Your Visuals

Organize the charts and text boxes on your report page logically. Drag and resize them to create a clean layout. A good practice is to place your most important high-level numbers (KPIs like total sales) in the top-left corner, as that’s where people naturally look first. Let your other charts tell a story, perhaps flowing from a high-level summary down to more detailed breakdowns.

Pinning to Your Dashboard

Remember, the dashboard is your one-page summary. Dashboards can’t contain interactive slicers or filters, so it's a static view of your most important numbers and visuals.

1. Hover your mouse over a visual you want to include in the dashboard (e.g., your “total sales amount by category” chart).
2. An icon of a pushpin will appear. Click the Pin icon.
3. A dialog box will pop up asking which dashboard you want to pin to. Since this is your first one, select "New dashboard," give it a name like "Sales Overview," and click "Pin."
4. Repeat this process for every other key visual on your report. You can pin a card with total sales, a map showing regional performance, and your smart narrative text block.

Once you’ve pinned your visuals, a popup on the right side will let you click “Go to dashboard.” Here, you can rearrange and resize your pinned "tiles" to create the final at-a-glance view for you and your team.

Final Thoughts

Creating a Power BI dashboard is no longer a complex task reserved for data experts. By leveraging built-in AI tools like Q&A and Smart Narratives, anyone can ask simple questions in plain English and get back insightful, easy-to-understand visuals. This approach streamlines the entire reporting process, helping you focus on the story your data is telling, not the technical steps behind building the charts.

While Power BI's AI capabilities are great, sometimes the friction isn't just in building the charts - it's connecting all the scattered data sources you rely on in the first place. For teams drowning in data from Google Analytics, Shopify, Salesforce, and a dozen other platforms, this takes up valuable time. We built Graphed to solve this by creating a tool that connects your data sources in a few clicks. You can create real-time sales and marketing dashboards simply by describing what you want in a sentence, letting AI automate everything from data connection to visualization.