All Tutorials — Power BI Tutorials

Visualization Intermediate

Build a Finance Dashboard in Power BI

Finance reporting has a shape that generic dashboards ignore.

Oct 5, 2026 #dashboard#finance

Visualization Beginner

Build a Sales Dashboard in Power BI (Step by Step)

A sales dashboard is the most common first project in Power BI, and it is also the one most people get wrong.

Oct 5, 2026 #dashboard#sales

Data Modeling Intermediate

Snowflake Schema vs Star Schema in Power BI

Dimensional modeling is the backbone of a fast, maintainable Power BI dataset.

Oct 4, 2026 #data modeling#schema

Data Modeling Intermediate

Star Schema Design in Power BI: A Practical Guide

A star schema organizes your data model around a single fact table at the center, surrounded by dimension tables that describe the who, what, when, and where of each transaction.

Oct 4, 2026 #data modeling#star schema

Visualization Intermediate

Using Performance Analyzer to Find Slow Visuals in Power BI

Performance Analyzer is a pane inside Power BI Desktop that records what happens when a report page or a single visual renders.

Oct 3, 2026 #performance#optimization

Data Modeling Advanced

VertiPaq Analyzer: Optimize Your Power BI Data Model

Every Power BI Import model is stored in the VertiPaq engine, a columnar, in-memory database.

Oct 3, 2026 #performance#data model

DAX Formulas Advanced

DAX Optimization Techniques to Speed Up Power BI

DAX optimization is less about typing faster formulas and more about understanding what the VertiPaq engine and the formula engine actually do when a measure runs.

Oct 2, 2026 #performance#dax

Power Query Intermediate

Power Query Query Folding: How and Why It Matters

Query folding is the process where Power Query translates the steps you build in the editor into a single query statement that the source system executes on its own engine.

Oct 2, 2026 #performance#query folding

Visualization Beginner

How to Copy Conditional Formatting Between Visuals in Power BI

Conditional formatting in Power BI is stored per visual, per field, per formatting property.

Sep 30, 2026 #conditional formatting#tips

Visualization Intermediate

KPI Visual Conditional Formatting in Power BI

The KPI visual in Power BI is a small chart with a big constraint: it renders exactly one value per card, plus a trend axis, and it has no legend, no series color, and no per-category row

Sep 30, 2026 #conditional formatting#kpi

Visualization Beginner

Gauge Conditional Formatting in Power BI

The gauge visual has a reputation problem. Analysts either love it or dismiss it as a decoration that wastes dashboard space.

Sep 29, 2026 #conditional formatting#gauge

Visualization Intermediate

Line Chart Conditional Formatting in Power BI

A line chart in Power BI is built from a category axis, a value axis, and one or more series.

Sep 29, 2026 #conditional formatting#line chart

Visualization Beginner

Bar Chart Conditional Formatting in Power BI

A bar chart that renders every bar in the same shade of blue forces the reader to do the comparison work themselves.

Sep 28, 2026 #conditional formatting#bar chart

Visualization Intermediate

Conditional Formatting Based on a Measure in Power BI

Conditional formatting in Power BI splits into two worlds. The simple one is rules you set from a field in your data: sales above a threshold turn green, below turn red.

Sep 28, 2026 #conditional formatting#measures

DAX Formulas Advanced

DAX EARLIER Explained: Reference the Previous Row in a Nested Row Context

EARLIER in DAX lets you reach a parent row context from inside a nested iteration. Learn what it does, when you actually need it, and the modern alternatives.

Sep 23, 2026 #power bi#dax#earlier

DAX Formulas Intermediate

DAX Studio Getting Started: What It Does and How to Connect to Power BI

DAX Studio is the free tool for writing, tracing, and tuning DAX. Learn how to connect to a Power BI model, read a query plan, and find slow measures.

Sep 23, 2026 #power bi#dax studio#query plan

Time Intelligence Intermediate

Month-over-Month and Year-over-Year DAX: A Copy-Paste Template

Stop rewriting time comparisons. Use this copy-paste DAX template for MoM, YoY, MoM %, and YoY % that works with any marked Date table.

Sep 23, 2026 #power bi#time intelligence#month over month

DAX Formulas Beginner

Percentage of Total in Power BI: Three DAX Patterns and When to Use Each

Calculate % of total in Power BI with ALL, ALLEXCEPT, and a ratio measure. Learn which pattern respects slicers and which ignores them, with copy-paste DAX.

Sep 23, 2026 #power bi#percentage of total#dax all

Visualization Intermediate

Power BI Slicers: Sync, Hierarchy, and Bookmark-Driven Filtering

Slicers look simple but a messy set destroys a report. Learn sync slicers across pages, build hierarchy slicers, and drive filters with bookmarks.

Sep 23, 2026 #power bi#slicer#sync slicers

Power Query Beginner

Unpivot in Power Query: Turn a Wide Table into a Long Table the Right Way

Unpivot Columns in Power Query converts month-by-column reports into a tidy long format Power BI can model. Learn the exact steps, the pitfalls, and how to keep one column fixed.

Sep 23, 2026 #power bi#power query#unpivot

Data Modeling Advanced

Role-Playing Dimensions in Power BI: One Date Table, Multiple Relationships

A role-playing dimension is a single table used in multiple roles — Order Date, Ship Date, Due Date. Learn the three ways to model it in Power BI without breaking relationships.

Sep 23, 2026 #power bi#role playing dimension#date table

Visualization Intermediate

Conditional Formatting for Charts, Bar Charts & Gauges in Power BI

Charts don't use cell rules — they use Data colors conditional formatting. Learn how to color bars, columns, and gauge fills by value, measure, or rule, with worked examples for bar charts and KPI gauges.

Aug 28, 2026 #visualization#conditional-formatting#bar-chart

Visualization Intermediate

How to Copy Conditional Formatting in Power BI Reports

Power BI has no native copy-paste for conditional formatting between visuals — but you have three reliable ways to reuse color rules at scale. Learn how to share formatting with measures, JSON themes, and report-level settings.

Aug 28, 2026 #visualization#conditional-formatting#json-theme

DAX Formulas Advanced

Power BI DAX Optimization: 10 Patterns That Actually Speed Up Measures

Most slow Power BI reports are slow because of DAX, not the model. Learn the 10 optimization patterns that fix the majority of DAX performance problems, with copy-paste measures and Server Timings context.

Aug 28, 2026 #dax#optimization#performance

Data Modeling Intermediate

Power BI Performance Analyzer: A Practical Guide to Faster Reports

Power BI Desktop's Performance Analyzer tells you exactly which visual is slow and why. Learn to record, export, and read its data — plus how to turn those numbers into a fix using DAX Studio.

Aug 28, 2026 #performance#performance-analyzer#dax-studio

DAX Formulas Intermediate

DAX User-Defined Functions (UDF): Reusable Logic Without Calculation Groups

DAX UDFs went GA in June 2026. Learn how the FUNCTION keyword lets you package reusable parameterized logic — tax calculations, currency conversion, margin formulas — and call it from any measure or column.

Aug 3, 2026 #DAX UDF#user-defined functions#FUNCTION keyword

DAX Formulas Intermediate

Power BI Visual Calculations: The Complete Guide (2026 GA)

Visual Calculations went GA in May 2026. Learn how RUNNINGSUM, MOVINGAVERAGE, PREVIOUS, and other visual-level functions replace dozens of measures — with real Contoso examples and copy-paste code.

Aug 1, 2026 #visual calculations#running sum#moving average

DAX Formulas Advanced

DAX CALCULATE: The Function That Controls Everything

CALCULATE is the most powerful function in DAX, and the one most often misunderstood. This guide covers how filter context works, how CALCULATE modifies it, the four most common patterns every analyst needs, and the mistakes that produce silently wrong numbers.

Jul 28, 2026 #dax#calculate#filter-context

Time Intelligence Intermediate

DAX Time Intelligence: YTD, QTD, and MTD Complete Guide

Time intelligence is one of the most common — and most error-prone — areas of DAX. This guide covers TOTALYTD, TOTALQTD, TOTALMTD, DATEADD, and SAMEPERIODLASTYEAR, the calendar table requirements that make them work, and the five mistakes that produce wrong year-to-date numbers.

Jul 28, 2026 #time-intelligence#dax#ytd

DAX Formulas Intermediate

DAX Variables (VAR/RETURN): Write Cleaner and Faster Measures

DAX variables make complex measures readable, prevent repeated calculations, and eliminate an entire class of context-transition bugs. This guide covers the syntax, scope rules, four practical patterns, and the performance gains you get from using variables correctly.

Jul 28, 2026 #dax#variables#var

Data Modeling Intermediate

Power BI Star Schema: The Data Model That Scales

A star schema is the single most important design decision in your Power BI model. It determines query speed, DAX simplicity, and whether your report scales from 10,000 rows to 10 million. This guide covers the design principles, the star vs snowflake decision, and the five mistakes that kill model performance.

Jul 28, 2026 #data-modeling#star-schema#performance

DAX Formulas Intermediate

DAX SWITCH: Cleaner Conditional Logic Than Nested IFs

SWITCH replaces messy nested IF statements in DAX with clean, readable conditional logic. Learn the syntax, four practical patterns, and the mistakes that cause SWITCH to return blank results.

Jul 26, 2026 #dax#switch#conditional-logic

Data Modeling Advanced

DirectQuery vs Import Mode: Choosing the Right Power BI Storage Mode

Import Mode caches data in memory for fast queries, while DirectQuery sends every visual request back to the source database. Learn when to use each, how Dual mode works, and the performance trade-offs that determine your report architecture.

Jul 26, 2026 #data-modeling#directquery#import-mode

Visualization Intermediate

Power BI Field Parameters: Let Users Swap Metrics and Dimensions

Field Parameters let report users dynamically switch between measures or dimensions in a single visual — no bookmarks, no separate pages. Learn setup, slicer integration, DAX integration, limitations, and common mistakes.

Jul 26, 2026 #visualization#field-parameters#dynamic-reports

Power Query Beginner

Power Query Group By: Aggregate Data Without Writing Formulas

Group By in Power Query lets you summarize rows by category — count, sum, average, min, max — using a visual interface. Learn the UI, advanced grouping with multiple columns, the M code behind it, and the mistakes that produce wrong totals.

Jul 26, 2026 #power-query#group-by#aggregation

DAX Formulas Intermediate

DAX RANKX: Rank Data in Power BI with Complete Control

RANKX is the DAX function for ranking rows by any measure or expression. This guide covers the syntax, the four ranking patterns every analyst needs, ties handling, and the common mistakes that produce wrong results.

Jul 23, 2026 #dax#rankx#ranking

Visualization Intermediate

Power BI Drill Through: Jump from Summary to Detail in One Click

Drill through lets users click a data point and jump to a detailed report page filtered to that specific context. This guide covers setup, filter passthrough, cross-report drill through, and the design patterns that make drill-through reports intuitive.

Jul 23, 2026 #visualization#drill-through#navigation

Data Modeling Intermediate

Power BI Row-Level Security: Control Who Sees What Data

Row-Level Security (RLS) filters data at the row level based on the user viewing the report. This guide covers static RLS, dynamic RLS with USERNAME(), deployment to the Power BI Service, and the design patterns for multi-tenant security models.

Jul 23, 2026 #data-modeling#rls#security

Power Query Beginner

Power Query Conditional Columns: Build If-Then-Else Logic Without Code

Conditional columns let you create new columns based on if-then-else logic using a visual interface — no M code required. This guide covers the UI, nested conditions, the M code underneath, and the patterns for categorizing, flagging, and bucketing data.

Jul 23, 2026 #power-query#conditional-columns#if-then-else

Visualization Beginner

Conditional Formatting in Power BI: A Complete Guide (Based on Measure, Formula & Text)

Learn every type of conditional formatting in Power BI — background color, font color, data bars, and icons — plus how to drive them with a measure, a formula, or a text field. Includes copy-paste DAX and real Contoso examples.

Jul 20, 2026 #visualization#conditional-formatting#color-rules

DAX Formulas Intermediate

DAX Troubleshooting Guide: Fix the 15 Most Common Errors

DAX errors are notoriously unhelpful. This guide covers the 15 most common DAX errors — from blank results to wrong totals to circular dependencies — with exact before-and-after fixes you can copy-paste.

Jul 20, 2026 #dax#troubleshooting#errors

DAX Formulas Beginner

10 Common Power BI Mistakes Beginners Make (And How to Fix Them)

Every Power BI beginner makes the same mistakes. This guide covers the 10 most common errors — from data types to DAX context to dashboard design — with exact fixes you can apply today.

Jul 20, 2026 #beginner#mistakes#dax

Visualization Intermediate

Power BI Dashboard Design: 12 Principles for Clear, Actionable Reports

A good Power BI dashboard isn't just charts on a page — it's a designed experience. Learn 12 principles for building dashboards that users actually understand and act on, from layout to color to interaction design.

Jul 20, 2026 #dashboard#design#ux

Data Modeling Advanced

Power BI Performance Optimization: A Complete Guide to Faster Reports and DAX

Slow Power BI reports frustrate users and kill adoption. Learn the systematic approach to diagnosing and fixing performance issues — from Performance Analyzer to DAX optimization to model tuning — with copy-paste patterns that actually speed things up.

Jul 20, 2026 #performance#optimization#dax

Visualization Intermediate

Build a Sales Dashboard in Power BI: End-to-End Tutorial

Follow a real-world project from raw data to finished dashboard. Learn data import, Power Query cleaning, star schema modeling, DAX measures, and visual design — all in one walkthrough.

Jul 20, 2026 #project#sales#dashboard

Visualization Intermediate

Power BI Tooltips: From Basic Hover to Full Page Reports

Tooltips are the most underrated interaction in Power BI. A default tooltip shows the data point's values — useful but limited. Custom tooltip pages turn a hover into a mini-report: related metrics, trends, and context. This guide covers building both and the three patterns where tooltips shine.

Jul 20, 2026 #visualization#tooltips#tooltip-pages

Time Intelligence Intermediate

SAMEPERIODLASTYEAR and Date Comparison Patterns in DAX

Year-over-year comparison is the most common business question in reporting. SAMEPERIODLASTYEAR is the simplest function for it, but it's just the start. This guide covers YoY, MoM, QoQ, and the custom comparison patterns for fiscal calendars and non-standard periods.

Jul 20, 2026 #dax#sameperiodlastyear#yoy

Visualization Intermediate

Bookmarks and Navigation in Power BI: Build Interactive Report Tours

Bookmarks capture the state of a report page — filters, selections, visibility, and sort order. Combined with buttons, they turn a static page into an interactive experience: tabbed navigation, drill-through stories, and self-guided report tours. This guide covers the mechanics and four patterns that work.

Jul 19, 2026 #visualization#bookmarks#navigation

Power Query Beginner

10 Common Power Query Transformations Every Analyst Should Know

Power Query has hundreds of functions, but a small set covers the vast majority of real-world cleanup tasks. This guide walks through ten transformations that handle messy exports, inconsistent naming, and malformed data — the daily reality of every data analyst.

Jul 19, 2026 #power-query#transformations#cleanup

Time Intelligence Intermediate

Rolling Averages and Moving Sums in DAX: Smooth Out the Noise

Daily data is noisy — a slow Tuesday followed by a spike Wednesday. Rolling averages and moving sums reveal the trend underneath. This guide covers the 7-day rolling average, the 30-day moving sum, and the pattern for any custom rolling window using DAX window functions.

Jul 19, 2026 #dax#rolling-average#moving-sum

Visualization Beginner

Power BI Visual Types: A Practical Guide to Choosing the Right Chart

Power BI offers dozens of visual types, but most reports use the same handful. This guide covers the core visuals — bar, line, card, matrix, map, and scatter — with guidance on when each is appropriate, common mistakes, and the visual hierarchy that makes reports readable.

Jul 18, 2026 #visualization#charts#bar-chart

Power Query Intermediate

Power Query Parameters: Build Dynamic, Reusable Data Sources

Parameters let you control Power Query behavior without editing the M code — swap environments, change date ranges, or toggle between production and test data with a dropdown. This guide covers creating parameters, using them in queries, and the pattern for environment switching.

Jul 18, 2026 #power-query#parameters#dynamic-sources

Power Query Beginner

Merge vs Append Queries in Power Query: Which One Do You Need?

Merge and append are the two ways to combine tables in Power Query, and they do completely different things. Merge is a SQL-style join — it adds columns. Append is a union — it stacks rows. This guide covers the difference, the join types, and the performance implications of each.

Jul 17, 2026 #power-query#merge#append

Data Modeling Intermediate

Calculated Tables and What-If Parameters in Power BI: Dynamic Modeling Tools

Calculated tables let you build tables with DAX instead of loading them from a source. What-if parameters turn static assumptions into interactive slicers. This guide covers both features, the syntax, and five practical patterns — from date tables to scenario analysis.

Jul 16, 2026 #data-modeling#calculated-tables#what-if-parameters

Power Query Beginner

Power Query M Language Basics: Functions, Tables, and Records

M is the functional language behind Power Query. It looks nothing like DAX or Excel formulas, but once you understand its three core data structures and how functions compose, the editor becomes far less intimidating. This guide covers the fundamentals with practical examples.

Jul 16, 2026 #power-query#m-language#functions

DAX Formulas Intermediate

DAX Variables (VAR): Write Cleaner Measures That Run Faster

Variables in DAX do more than make code readable — they cache intermediate results, prevent repeated calculation, and make complex logic testable. This guide covers the syntax, the performance benefit, and five patterns where variables transform unreadable measures into maintainable code.

Jul 15, 2026 #dax#variables#var

DAX Formulas Beginner

SUMX vs SUM in DAX: When Iterators Matter and When They Don't

SUM is simple and fast. SUMX is flexible and powerful. Choosing the wrong one leads to incorrect totals or bloated models. This guide covers the difference, when each is appropriate, and the three patterns where SUMX is the only correct choice.

Jul 14, 2026 #dax#sumx#sum

Data Modeling Advanced

Bidirectional Filtering in Power BI: When It Helps and When It Hurts

Bidirectional filtering is powerful and dangerous. It solves certain modeling problems elegantly — and creates performance disasters and ambiguous filter paths when overused. This guide covers what bidirectional filtering does, the three scenarios where it's the right tool, and the warning signs that you're using it wrong.

Jul 13, 2026 #data-modeling#bidirectional-filtering#cross-filter

Data Modeling Intermediate

Star Schema Data Modeling: The Foundation of Fast Power BI Reports

A well-designed star schema makes DAX easier and reports faster. Learn fact vs. dimension tables, relationship cardinality, and why bidirectional filters are usually a mistake.

Jul 13, 2026 #data-modeling#star-schema#relationships

DAX Formulas Intermediate

Filter Context vs Row Context in DAX: The Core Mental Model

Filter context and row context are the two evaluation contexts that govern every DAX formula. Most calculation errors trace back to confusing them. This guide breaks down both, shows how they interact, and gives you the mental model to predict formula behavior before you write it.

Jul 12, 2026 #dax#filter-context#row-context

Data Modeling Intermediate

One-to-Many vs Many-to-Many Relationships in Power BI: A Practical Guide

Relationship cardinality determines how filters flow through your data model. One-to-many is the default and the safest choice. Many-to-many is sometimes necessary but introduces ambiguity and performance costs. This guide covers both, when each is appropriate, and the patterns that make many-to-many manageable.

Jul 11, 2026 #data-modeling#relationships#cardinality

Time Intelligence Intermediate

Time Intelligence in DAX: YTD, YoY, and Rolling Patterns That Work

Time intelligence is 80% of business reporting. Learn the calendar table setup, YTD/QTD/MTD functions, year-over-year comparison, and the rolling-average pattern every analyst needs.

Jul 6, 2026 #dax#time-intelligence#ytd

Power Query Beginner

Getting Started with Power Query: Clean and Shape Data in Power BI

Power Query is the ETL engine behind Power BI. Learn to connect, transform, and shape data with a no-code interface plus a peek at the M language underneath.

Jun 29, 2026 #power-query#etl#m-language

DAX Formulas Intermediate

CALCULATE: The Most Important DAX Function Explained

CALCULATE is the only function that can modify filter context. Master its syntax, evaluation order, and three real-world patterns that unlock every advanced DAX formula.

Jun 22, 2026 #dax#calculate#filter-context

DAX Formulas Beginner

DAX Basics: The Beginner's Guide to Data Analysis Expressions

Learn what DAX is, how measures differ from calculated columns, and write your first five formulas with confidence. A practical starting point for every Power BI analyst.

Jun 15, 2026 #dax#basics#measures