Learn how to use Power BI in your organization from our useful Microsoft Power BI tutorials.
Recently, one of my subscribers emailed me to update the tutorial on card visualization in Power BI. So, here is the complete updated tutorial on card visual in Power BI. I will explain what a card visual is in Power BI and how to create a card in Power BI. I will also explain how … read more…
Power BI is a powerful tool made by Microsoft for showing data and better understanding the business. It has many useful features to improve reports. One such feature is sync slicers, which allows users to synchronize Slicer across multiple report pages or visuals within a report. This tutorial will teach us about the Power BI … read more…
Are you stucking with the “Access to the resource is forbidden” error in Power BI, especially when trying to connect to a SharePoint Online list? In this Power BI article, I will tell you how to fix the access to the resource is forbidden error in Power BI. Power BI Error: Access to the Resource … read more…
I’m sure as an analyst, you may have once been faced with the challenge of some data with a date field in the format ‘YYYYMMDD’ (e.g., 20240306) and want to transform it to a proper date format (e.g., 06–03–2024). In this tutorial, I will show you how to change yyyymmdd to date format in Power … read more…
Did you know that using Power BI Service’s “Publish to web” option is the best approach to sharing your report with other users, whether they are members of a specified security group or the entire organisation? But when you Publish to the web in Power BI, you may face errors like “Contact your admin to … read more…
The WEEKDAY function in Power BI helps you understand and analyze your data based on the day of the week. In this Power BI tutorial, we learned what the weekday function of Power BI is and how to use Power BI Weekday function with an example. Additionally, I will explain how to utilize the weekday() … read more…
If you want to convert hours values to minutes in Power BI, it is not as straightforward as multiplying it by 60. This is because Power BI has a specific way of storing date and time values in Power BI. In this Power BI Tutorial, We will discuss how to convert hours to minutes in Power … read more…
Most of my work involves getting data from various sources, such as Excel, SharePoint lists, databases, etc. In most cases, the first step is to clean the data and make it usable for my analysis. Sometimes, when I have datasets, a column has empty spots. If I use this column in a Power BI slicer, the first … read more…
If you use Power BI DAX (Data Analysis Expressions), you might encounter the NaN Error when dividing the column. In this short tutorial, I will show you how to quickly solve this error in Power BI (using some easy DAX tricks). I will also show you how to solve NaN error in Power BI with … read more…
A Power BI visual becomes difficult to read without data labels. At the same time, adding data labels in Power BI visualization is a good practice. Many analysts often include data labels in their visuals. You might wonder what a data label is in Power BI. Don’t worry. In this Power BI tutorial, we will … read more…
Power BI is a great tool for data analysis. When people first learn Power BI DAX (Data Analysis Expressions), they often begin with basic arithmetic calculations like addition, subtraction, multiplication, and division. In this tutorial, I will demonstrate how to subtract in Power BI using DAX (Calculate column, Measure). We will also discuss how to … read more…
Power BI can be quite useful when we are working on dates. It has some powerful built-in formulas that allow you to do calculations based on dates. One common scenario where you have to perform calculations with dates would be to find out how to calculate monthly sales. In this tutorial, we will learn how … read more…
This Power BI tutorial will help how to add data to existing table in Power BI. Recently, while working on a Power BI report, I encountered a situation where I needed to add data to an existing table. The Append feature in the Power Query Editor of Power BI proved very helpful in this scenario. … read more…
If you are having trouble organizing your data in Power BI, the Power BI measure table can be helpful. In this Power BI tutorial, we will look at the idea of a Power BI measure table, how to create a measure table in Power BI, and how to add the measure to the measure table … read more…