Power BI Tutorials

As a data analyst, you’re ofte tasked with analyzing performance for Time-based analysis. In a Sales Analysis use case, you…

“I have a column in my HR dataset containing full names (e.g., ‘Aisha Patel’). How can I split this into…

A colleague of mine asked how to convert raw sales figures into percentages of total sales for each product category…

How can I filter a column in Power BI based on specific conditions? I have an HR dataset and need…

User Question: “I have a large HR dataset with employee information, but some rows contain irrelevant or outdated data. How…

Here’s question from a reader: I have a large dataset in Power BI and need to exclude certain records based…

When preparing our data for analysis we often deal blank rows which oftern skew our analysis and visuals. Let’s explore…

As a data analyst, you’ve created a dashboard containing tables and matrices. Now, you need to share this data with…

User Question: “I have name and email columns with inconsistent text formatting in my HR database. How can I standardize…

Here’s a question from a colleague: I’m working with employee performance data in Power BI, and our ratings are stored…

I have employee time tracking data, and I need to analyze and visualize work durations in different formats for reporting…

I have a dataset with employee performance reviews, including periodical HR review dates. Need to create a visual in Power…

Use case I have a column in my database in which i have an employee IDs that is mixed with…

Question I have an HR attendance dataset with UTC timestamps, but I need to display local times in my Power…

I have a column in my database containing employee start dates, but they’re stored as text strings in various formats…

Here’s a question from Joey : I’m creating performance reports in Power BI, and I need to add a target…

Problem statement:“I’m working on an HR Power BI report and need to fill a column with values based on another…

Here’s a question from our Facebook group: I have a Power BI dataset with employee information, but I need to…

I’m working with employee data in Power BI and need to identify missing values in certain columns. How can I…

Our challenge for today is to help create a dynamic title in Power BI that changes based on filter selections….

Here’s a question from a friend’s colleague:“How can I create a dynamic top N filter in Power BI to show…

Here’s a question from a reader: “How can I replace null values in my data using Power Query in Power…

User Question: “How can I join two tables in Power Query based on matching values in two different columns?” Joining…

Here’s a question from a colleague: “How can I create a rolling 12-month average measure to calculate employee turnover rate…

Here’s a question from a colleague:In our HR department, we often need to report based on our company’s fiscal year,…

Converting your data to different types is a common (and time consuming :-)) task in data transformation. Power Query provides…

Here’s a question from David: Is there a Power BI function that allows to create a table showing specific values…

Here’s a question from Thomas: Sometimes, while building a model in Power BI Desktop, i would like to create a…

Here’s a question from Marla: I have imported a table from Excel. When i bring it up in Power BI…

Problem Statement You have imported a dataset from Excel or an SQL database. The dataset has columns containing numeric data…

Here’s a question from a reader: I have a table containing date time information in a mm/dd/yyyy format. When importing…

Here’s a question from Judy: I have a large data set for which i create a calculated column that contains…

Step #1 : Import your data Start by importing your dataset in Power BI. In our example we will use…

Here’s a question from Jason: I have a dataset containing sales orders info. I need to group data from different…

Step 1: Identify your date fields This fictitious company has a target to finalize the candidate interviewing process in less…

Step 1: Import your Data to Power BI If you haven’t acquired your dataset, make sure to import it into…

Step 1: Identify the column to multiply In this example, we would like to show how we multiply two columns…

Step # 1: Define your measures and columns In this example, we will work with a subset of our Course…

Here’s a question from Alice: I am working on a dashboard which includes a stacked bar chart. Need to add…

Here’s a question from Louis: A key user asked me to help create a report to dynamically filter contents of…

Here’s a question from Harry: I have a table with sales data. I would like to create a Power Bi…

Here’s a question from our reader Melissa: Quick question here: i am using the MONTH DAX function in Power BI…

Vanessa asks: Just getting started with Power BI and trying to make a simple analysis of sales using a table…

Combine two columns into one in Power BI To join two our columns in your Power BI data model table,…

Calculate number of days between two days in Power BI To find the number of days in between two dates…

Create a year column in Power BI You can add a year variable to your BI data model by following…

Use the following DAX expression to check whether a table column in your Power BI data model contains a specific…

To cast a Power BI column from integer or decimal format to string texts use the following DAX code: Import…

Couple of days ago, while working with a simple csv file, i had to cast a column of integers using…

Here’s a question from Kevin: I have a date time column in one of my Power BI data model table…

Melvin asks: I have a date column in my Power BI model. Can you explain how to create both month…

Here’s a question from our reader, Martina: I have a table that contains date values. For reporting purposes, i would…

Here’s a question from Emilio: I loaded an Excel spreadsheet to my Power BI desktop app, and inserted a stacked…