Learn how to use Power BI in your organization from our useful Microsoft Power BI tutorials.
While working on Power BI reports, I receive data from multiple tables or different data sources. Many times, the information we need is split across these tables, and using them separately can cause issues when creating table visuals in Power BI. To solve this problem, we need to merge tables in Power BI. We can … read more…
While working on a Power BI report for a Sales team, one of my colleagues asked me how to convert numbers to text in Power BI. This was because, in the source data, one column contained both numbers and text values. When this column was used in a chart or visual, Power BI started showing … read more…
I was working on a Power BI report, and I noticed that some columns, like Employee ID, Customer Code, or Product Number, were stored as text and had leading zeros, for example, 000123. When I use this column in a report and try to sort or filter the data, I am not getting the correct … read more…
Recently, I was working on a Power BI report for a client. They wanted to create a report for their marketing team, where users can click on a visual and see more information related to that item. In their dataset, they already have a URL column. The requirement was to show this URL in a … read more…
When we add data to Power BI, we can sort the data in ascending or descending order. But in this case, I want something different. The marketing team wants to see sales data grouped and ordered by Customer Location so they can quickly understand which locations are performing better. To achieve this, we need to … read more…
When we are working on a Power BI report for a client, one of my colleagues asked me a question like this: This is what the index column shows now: But this was not the expected result. They wanted the index column to be like this: This means the same Department should have the same … read more…
Last week, when I created a Power BI report for the Finance team, I received the data from SQL. After loading it into Power BI, I noticed that some fields had the wrong data type. For example, a few columns were loaded as text, but they should have been numbers. To change the data type, … read more…
While working in Power BI, one of my colleagues asked me, “Is there a way to set the data type when creating a new column in Power Query?” This happened because when we add a column, Power Query does not automatically assign the correct data type. Usually, we first create the column and then change the … read more…
While creating a dashboard for an organization, I realized I needed a few empty columns. To do this, Power BI provides multiple ways to create empty columns, depending on whether you’re working with DAX or Power Query. In this tutorial, I will show you all the practical methods to add an empty column in Power … read more…
Last week, one of my subscribers asked me a question about filters in Power BI. They have a budget table with budget values for all 12 months, and actual values for only 9 months. They wanted to create a DAX measure that shows the full-year budget even when the Month filter is selected on the … read more…
We are working on a report for our client, and during the discussion, one of my colleagues asked me a question. They wanted to calculate how many customers placed an order in the last 30 days, for a specific product category, and whose total purchase amount is above 10,000. I told them we can easily … read more…
A few days ago, I was working on a Power BI report where the client needed some special filters. They wanted to see sales above a certain number, show only active records, and apply more than one condition at the same time using DAX. The normal Power BI filters could not do this, so I … read more…
A few days ago, I was creating a dashboard for a client where they needed to analyze their data using different date conditions. They wanted to see records greater than a certain date, compare data before a specific date, and even view trends between two selected dates. Since these filters had to work dynamically inside … read more…
Today, I received an email from a user who wanted to create a DAX measure to count how many distinct companies sold 10 or more items in a week. They wrote a DAX formula like this: Count above 10 =CALCULATE( DISTINCTCOUNT(Table1[Company]), FILTER(Table1, SUM(Table1[Items sold]) >= 10)) But this did not work. The reason is that … read more…
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Learn how to build a SharePoint Permission Checker Agent using Copilot Studio. Using this agent, you can check library-level and file-level permissions. Also, identify Users, SharePoint Groups, and Permission Levels.
📅 1st July 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App