To keep things simple, all Power BI tutorials are grouped into 5 main sections that you can scroll through and jump into:
- Power BI fundamentals, data modeling, and integration
- DAX measures, filters, and calculations
- Power Query transformations and data shaping
- Visualizations, slicers, and conditional formatting
- Security, sharing, export, and real‑world scenarios
You can start at the top and move down, or jump straight to the section that matches what you are doing today.
What is Power BI, and why use it?
Power BI is Microsoft’s business intelligence and data visualization platform that lets you connect to multiple data sources, model data, write DAX calculations, and build interactive reports and dashboards. It is designed so business users and developers can both turn raw data into clear insights.
Organizations use Power BI to analyze SharePoint and Dataverse data, track KPIs in dashboards, build paginated or PDF reports, and publish self‑service analytics for teams or the whole company, including embedding reports into SharePoint Online and Power Pages.
Who is this Power BI tutorials hub for?
This Power BI tutorials hub is for beginners who want to build their first report as well as analysts and BI professionals who need concrete DAX, Power Query, and visualization patterns. If you are new, you can treat this page as a guided learning path.
If you already work with Power BI, you can use this hub as a reference library any time you need a specific pattern—like a DAX time‑intelligence measure, a conditional formatting rule, a slicer trick, or a Power Query transformation.
1. Power BI fundamentals, data modeling, and integration
Use this section to understand how Power BI works, how to create basic reports, work with tables and relationships, and connect to SharePoint and Dataverse.
- Compare licensing options with Power BI Free vs Pro vs Premium
- Create your first report in Desktop using Create a report in Power BI Desktop
- Work with tables visually via Power BI table visualization
- Add more data into existing models with Add data to existing table in Power BI
- Create a separate table for measures using Create a measure table in Power BI
- Create tables based on others with Power BI create table from another table
- Group rows in tables using Power BI group by and Power BI group by column
- Group data by a measure with Power BI group by measure
- Merge two tables without duplicates via Power BI merge two tables without duplicates
- Union tables using Power BI union two tables
- Add columns from another table via Add column from another table in Power BI
- Create relationships when keys aren’t unique using Create a relationship in Power BI without unique values
- Understand row‑level vs object‑level security using Power BI row‑level security vs object‑level security
- Connect to Dataverse data with Dataverse Power BI – connect and build reports
- Embed reports into SharePoint using Embed Power BI report in SharePoint Online
- Display Power BI reports in portals with Display Power BI reports in Power Pages
- Export data to Excel via Power BI export to Excel
2. DAX measures, filters, and calculations
Use this section to write measures and calculated columns in DAX: counting, sums, IF logic, filters, MIN/MAX, date/time intelligence, and percentage calculations.
- Get an overview of DAX with Power BI DAX – complete guide
- Use IF logic via Power BI IF function
- Use SWITCH for multiple conditions with Power BI SWITCH and Power BI SWITCH multiple conditions
- Handle nulls using Power BI IF null then 0 and Check if text is null in Power BI
- Count rows using Power BI DAX COUNT and Power BI COUNT IF true
- Sum and subtract in one measure via Power BI measure sum and subtract
- Divide columns correctly with Power BI divides two columns and Subtraction in Power BI using DAX
- Filter Power BI Data Dynamically with Power BI DAX FILTER with SELECTEDVALUE
- Work with MIN and MAX using:
- Calculate percentages with:
- Work with text in measures using Power BI measure IF text and Power BI measure IF multiple conditions
- Perform concatenation with Concatenate with space in Power BI and Concatenate text and number in Power BI
DAX filters and time intelligence
- Filter tables with Power BI DAX filter
- Filter tables by conditions using Power BI DAX filter table and Power BI DAX filter IF
- Filter rows using conditions from another column via Power BI DAX filter rows using conditions from another column
- Filter by date ranges using:
- Use CALENDAR/date tables via Power BI DAX CALENDAR function
- Compare month‑over‑month using Power BI month over month change
- Use TODAY and current date logic via Power BI DAX TODAY
- Use WEEKDAY function via Weekday function in Power BI
- Compare two columns in different tables with Power BI compares two columns in different tables
- Remove filters in calculations using Remove filter from Power BI DAX and Remove filters in Power BI DAX
- Group and sum using Power BI sum group by and Power BI DAX groupby with filter
3. Power Query transformations and data shaping
Use this section when you are cleaning and transforming data before it hits the model: splitting columns, adding conditional columns, changing data types, and extracting or converting values.
- Change data types in reports using Power BI change data type
- Change data types in Power Query via Change data type in Power BI Power Query
- Add an empty column to a table using Add empty column in Power BI
- Add a column with a fixed value via Add column with fixed value in Power BI
- Add a column if text contains a value using Add column if contains in Power Query Power BI
- Add a column if blank or null via Add column if blank or null Power BI Power Query
- Extract text and add a column using Power Query extract text and add column in Power BI
- Split columns into multiple parts using Split columns in Power BI
- Merge columns together with How to merge column in Power BI
- Add an index column via Add index column in Power Query Power BI
Conversions and text/number cleanup
- Convert YYYYMMDD numbers to date using Power BI convert YYYYMMDD to date
- Convert hours to minutes with Power BI convert hours to minutes
- Convert number to text via Power BI convert number to text
- Convert decimal to text using Convert decimal to text in Power BI
- Convert text to number via Convert text to number in Power BI
- Convert date to text using Power BI convert date to text
- Convert local time to UTC via Convert local time to UTC in Power BI Power Query
- Remove leading zeros from fields via Remove leading zeros in Power BI
- Add leading zero to month using Power BI add leading zero to month
- Handle ZIP codes starting with 0 via Power BI ZIP code starting with 0
4. Visualizations, slicers, and conditional formatting
Use this section to design clear visuals and interactions: charts, cards, matrices, slicers, bookmarks, and all the conditional formatting tricks that make reports easy to read.
- Build table views with Power BI table visualization
- Create card visuals using Power BI card and Power BI multi‑row card
- Use matrix visuals via Power BI matrix multiple column
Charts and dashboards
- Build bar charts via Stacked bar chart in Power BI
- Build line charts with Line chart in Power BI
- Create pie charts and format them using Power BI pie chart and Conditional formatting in Power BI pie chart
- Create clustered column charts with Clustered column chart in Power BI
- Build interactive dashboards via Power BI dashboard – add title, image, and video
- Show data labels clearly using Data labels in Power BI
Slicers and interactivity
- Use date filters via Power BI date slicer and Power BI date slicer by month
- Set default and “to today” ranges using Power BI date slicer between a default to today
- Make slicers only show dates with data via Power BI date slicer only shows dates with data
- Add dropdown slicers via Add a dropdown slicer in Power BI
- Let users select multiple values using Power BI slicer multiple selection and Power BI slicer multiple columns
- Sort slicers by another column with Sort slicer by another column in Power BI
- Sort slicers descending via Power BI slicer sort descending
- Sort slicers by a measure using Sort slicer by measure in Power BI
- Remove blank values from slicers via Remove blank from Power BI slicer
- Sync slicers between pages using Power BI sync slicers
Conditional formatting and table styling
- Change color based on values using Power BI change color based on value
- Apply conditional column logic via Power BI conditional column
- Use conditional formatting based on field value with Power BI conditional formatting based on field value
- Format based on text values using Power BI conditional formatting based on text
- Apply table conditional formatting via Power BI table conditional formatting
- Show positive vs negative values clearly with Power BI conditional formatting positive and negative numbers
- Apply multiple value rules in bar charts via Power BI bar chart conditional formatting multiple values
- Center values in table columns using Center values in Power BI table
5. Security, sharing, export, and real‑world scenarios
Use this section for all the “production‑ready” parts of Power BI: security, embed and access issues, export, and important real‑world patterns.
- Implement row‑level security using Power BI row‑level security
- Protect specific objects with Object‑level security in Power BI
- Compare RLS vs OLS with Power BI row‑level security vs object‑level security
- Handle forbidden access with Access to the resource is forbidden Power BI
- Fix embed code issues using Contact your admin to enable embed code creation Power BI
- Understand username vs userprincipalname via Difference between USERNAME and USERPRINCIPALNAME in Power BI DAX
- Compare cross filter options with Power BI cross filter direction
- Export reports to PDF using Power BI report export to PDF
- Export data to Excel via Power BI export to Excel
- Use What‑If parameters with:
- Handle common errors using:
- Prepare for interviews and roles via Power BI interview questions and answers
How to use this Power BI tutorials hub
You can use this Power BI hub in two ways. If you are new, start with Power BI fundamentals, data modeling, and integration, then move into DAX measures and calculations, followed by Power Query transformations and Visualizations and slicers while you build your first real report.
If you already work with Power BI, bookmark this page and treat it as your pattern library. Whenever you face a specific problem—like a tricky DAX date filter, a slicer sorting issue, or a Power Query transformation—scroll to the matching section and open the relevant tutorial directly from there.
Explore other tutorial hubs
Power BI becomes much more powerful when you combine it with the rest of the Power Platform and Microsoft 365. Use these hubs alongside your Power BI work to build end‑to‑end business solutions:
- Build apps that feed data into your reports with all Power Apps tutorials
- Automate data refreshes, exports, and notifications with all Power Automate tutorials
- Work with SharePoint lists and libraries that supply data to your models using all the SharePoint tutorials
- Design external‑facing portals that surface Power BI reports with all Power Pages tutorials
- Build AI copilots that answer questions about your data using all Copilot Studio tutorials
- Strengthen administration and scripting around your BI environment with all PowerShell tutorials
Join the premium SPGuides Academy
If you want to move beyond individual tips and see complete Power BI projects from start to finish, you can join the premium SPGuides Academy. Inside the academy, you’ll find structured courses and real‑time projects that show how to design data models, write production‑ready DAX, build interactive dashboards, and integrate Power BI with SharePoint, Power Apps, Power Automate, and Dataverse.
You can follow guided learning paths, download sample files, and watch step‑by‑step implementations—from data preparation and modeling all the way to security, sharing, performance tuning, and governance for real‑world BI solutions.
Final thoughts
This Power BI tutorials hub is designed to be your single place for learning and troubleshooting—from your very first report to advanced DAX, Power Query, and security scenarios. With 150+ tutorials grouped into a few clear sections, you can quickly find exactly the example you need and apply it directly to your own reports and dashboards.
As you build more real projects, keep coming back to this hub: the more you pair hands‑on practice with these targeted tutorials, the faster your Power BI skills and confidence will grow.
