Power BI

Power BI Tip: How to Sort a Column with Duplicates by Another Column

If a column in your table has duplicate values, Power BI won’t allow you to sort it by another column, unless both columns have the same granularity. To set a different column to sort by in Power BI, both columns need to be at the same level of granularity. For example, you need a column

Power BI Tip: How to Sort a Column with Duplicates by Another Column Read More »

Transform Multiple Columns Based On Other Columns In Power Query With A Single Step

Here is a Power Query ETL workaround that I implemented to transform multiple columns using a single step based on another column in the same table. I had to deal with this challenge in my most recent Power BI project on Financial Reporting. When using just the interface (GUI), it may take more steps and

Transform Multiple Columns Based On Other Columns In Power Query With A Single Step Read More »

Power BI DAX Challenge – 2 with Solution | How to Measure Marketing Campaign Success?

Power BI DAX Challenge – 2 with Solution. In this video, we examine a query posed by Amazon during a job interview. Identifying how many users are eligible for a in-app marketing campaign is a the task. Although it requires applying some challenging logic, DAX makes it simpler to do in the end. To solve

Power BI DAX Challenge – 2 with Solution | How to Measure Marketing Campaign Success? Read More »

Interesting DAX Challenge – 1 | Cross Join Football Teams for Matches in Power BI

In this video, ExcelFort presents its first Power BI DAX challenge. An interesting DAX challenge with a solution is presented in this video. You can download the source data and completed files to solve the problem yourself and compare my solution to your own or share your alternative solution in the comments section below. This

Interesting DAX Challenge – 1 | Cross Join Football Teams for Matches in Power BI Read More »

Dynamic Accounts Receivable (AR) Dashboard in Power BI

An Accounts Receivable (AR) can mean the amount of money a customer owes a company for goods or services they received, or the process of converting their debt into cash. Therefore, managing AR is such a critical business process, and the quality of AR can determine whether or not a company thrives. A dashboard that

Dynamic Accounts Receivable (AR) Dashboard in Power BI Read More »

Budget Allocation with Seasonality in Power BI | Step by Step Tutorial

In this video, I will show you how to allocate a sales budget with monthly seasonality percentages into values by different timeframes using Power Query. Understanding how to use an allocation factor can be a huge help when distributing budget values across different time periods. With the power of Power Query and Power BI, you

Budget Allocation with Seasonality in Power BI | Step by Step Tutorial Read More »

How to SWITCH Power BI TOOLTIP PAGE | Made EASY with Bookmark Navigator

This video shows you how to replace the default boring tooltip in Power BI with a visually rich report page tooltip that appears when you hover over a visual. Using the bookmark navigator, I will show you how to let your users choose what is displayed on the tooltip according to their preferences. By using

How to SWITCH Power BI TOOLTIP PAGE | Made EASY with Bookmark Navigator Read More »

How to Make ELEGANT In Page Navigation with Power BI Bookmark Navigator

The Power BI Bookmark Navigator is a new feature that can be used to create an elegant in page navigation for your Power BI dashboards. It’s the perfect solution if you want to provide your users with quick access to different views within your dashboard to switch between different bookmarks in Power BI.  In this

How to Make ELEGANT In Page Navigation with Power BI Bookmark Navigator Read More »

Power BI DAX Webinar | Why Do My DAX Formulas Return Wrong Results? | M365 Chicago

In this webinar, I showed how to find and fix DAX formulas errors in Power BI. Learn why your DAX formulas return wrong results and how to identify the problems and correct them.  DAX is a powerful language that can make the tasks of data analysis and reporting in Power BI and Excel easier. However,

Power BI DAX Webinar | Why Do My DAX Formulas Return Wrong Results? | M365 Chicago Read More »