Learn how to use Power BI in your organization from our useful Microsoft Power BI tutorials.
If you’ve ever built a beautiful Power BI report and then had a colleague say, “Can you just send me the data in Excel?” — you know the feeling. You built all those visuals, and now someone wants a flat file. Microsoft provides multiple ways to get your Power BI data into Excel. In this … read more…
If you’ve ever landed on the Power BI pricing page and felt confused about which plan to pick — then this tutorial is for you. I get this question a lot: “What’s the real difference between Power BI Free, Pro, and Premium?” The honest answer is: it depends on what you’re trying to do. Are you … read more…
Recently, I was working on a Power BI report. At first, everything looked fine. The data was loading properly, visuals were created, and slicers were added. But when I started using a date column in charts and filters, I noticed some issues. The dates were not showing correctly. In some visuals, Power BI treated the … read more…
While working for a client, I faced a requirement where the report needed a daily filter that automatically reflects the current date. The client wanted the report users to filter data every day without manually selecting the date each time. To achieve this, I decided to add today’s date as a separate column in the … read more…
When I need to detect empty or missing values in a dataset, I use DAX functions in Power BI. In DAX, we have two functions, ISBLANK and ISEMPTY, and at first, they look like they do the same thing. Both functions return TRUE when something is empty and FALSE when data exists. Because of this, … read more…
I am working on a report for an organization, and I faced a requirement to identify and handle blank values in Power BI reports. Several columns contained empty data, which we did not want to consider in reports. Power BI provides multiple DAX functions, such as ISBLANK, COALESCE, FIRSTNONBLANK, and LASTNONBLANK, to identify, remove, or … read more…
One of my colleagues asked me how to join the First Name and Last Name columns in Power BI and add a space between them. He had tried creating a calculated column using the following DAX formula: However, this caused an error because the CONCATENATE function in DAX only accepts two arguments in the format … read more…
One of my colleagues asked me how to check if a text value is a date in Power BI Power Query. He was working on a report where a date field was stored in text format. When he tried to change the column data type to Date, Power BI showed errors for some rows. The … read more…
While working on Power BI reports for clients, I noticed that the data coming from Excel, SharePoint, or databases was rarely ready for reporting. In many cases, the values I needed were not available as separate columns. Instead, I had to create new columns from existing data, such as calculating values, applying simple business logic, … read more…
While working on a client report, there was a requirement to clean and format text data before using it in visuals. The source file contained values such as codes, names, and descriptions combined into a single column. The client wanted only specific parts of the text, such as the first few characters, the last value, … read more…
While working on a client report, there was a requirement to select multiple values from a slicer instead of choosing only one value at a time. The client wanted users to filter the report easily without holding the Ctrl key, and also needed the slicer to work across different visuals and tables. To solve this … read more…
Last week, one of my subscribers asked me a question about Power Query in Power BI. He was working with a Product table that has three columns: Product Key, Date, and Sold. For one Product Key, there are many records with different dates. The requirement was simple. He wanted to count how many times the … read more…
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…
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App
Download 135+ Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…