.svg)
Before You Begin
This tutorial assumes that Power BI Desktop is already installed and that an initial dataset has been loaded (for example, a sales export in Excel format, including date, product, quantity, and amount). The goal is to go beyond a simple, standalone chart: to build a dashboard with multiple interconnected visuals, a calculated measure, and consistent formatting.
Step 1: Check the structure of the data model
Before creating any visuals, switch to Model view to verify that your tables are properly linked (for example, a “Sales” table linked to a “Products” table via a product ID). A poorly structured model at this stage will cause calculation errors that are difficult to diagnose later on.
Step 2: Create Your First DAX Measure
In the "Fields" pane, right-click your sales table and select "New Measure." Create a simple measure that totals the sales amount:
Total Sales = SUM(Sales[Amount])
Unlike a calculated column, a DAX measure is dynamically recalculated based on the filters applied to the report (time period, product, region, etc.), making it essential for interactive dashboards.
Step 3: Add a measure with a filter (CALCULATE)
To compare sales in a specific category, for example, use the CALCULATE function:
Category A Sales = CALCULATE([Total Sales], Products[Category] = "A")
CALCULATE is the core function of the DAX language: it allows you to change the filter context of an existing measure without having to rewrite it entirely.
Step 4: Add a KPI card
Select the "Map" visual and drag your "Total Sales" metric onto it. This visual displays a key metric at a glance, making it ideal for the top of a dashboard to provide general context before delving into the details.
Step 5: Add a chart by period
Add a "Line Chart" or "Grouped Histogram" chart, with the date on the x-axis and your "Total Sales" metric as the y-axis value. This allows you to visualize trends over time, which is almost always necessary in a management dashboard.
Step 6: Add a detail table
Add a "Table" visual with columns for product, quantity, and amount, to allow users to view the details behind the aggregated numbers in the other visuals.
Step 7: Link the images to a segment
Add a "Segment" (slicer) visual for the product category. By default, all visuals on the page automatically filter each other: clicking on a bar in the chart will also filter the detail table and the KPI map, without any additional configuration.
Step 8: Format and Publish
Standardize the colors using the Theme tab, add a descriptive page title, and then publish your report to the Power BI Service using the "Publish" button on the Home ribbon (requires signing in with a work account associated with a Microsoft 365 tenant).
Common Mistakes to Avoid
- Use calculated columns instead of measures: Calculated columns slow down the model and do not respond to filters the way measures do.
- Overloading a page with too many images: it’s better to have several themed pages than a single page that’s hard to read.
- Ignoring relationships between tables: Incorrectly configured relationships produce incorrect calculation results without an explicit error message.
Further information
Once you have mastered these basics, the next steps generally involve exploring more advanced DAX measures (time-based analysis, period-to-period comparisons), setting up access governance in Power BI Service, and automating data refreshes.
Frequently asked questions
What is the difference between a calculated column and a DAX measure?
A calculated column is evaluated row by row and stored in the model, whereas a measure is calculated on the fly based on the filter context of the visual that displays it. Measures are the preferred choice for most aggregation calculations.
Do you need to be familiar with DAX to create a Power BI dashboard?
For a very simple dashboard, no—the basic aggregations (sum, average, count) are available without writing any formulas. As soon as conditional calculations or comparisons between time periods are needed, a basic understanding of DAX becomes essential.
Can you undo an action in Power BI Desktop?
Yes, the Ctrl+Z shortcut works to undo most recent actions, both on visuals and on transformations performed in Power Query.
For a structured Power BI deployment within your organization, IT Systèmes provides support for scoping, modeling, and training your teams. Learn more about our Power BI support services.
.svg)