In the Power BI March 2022 feature update, a new feature for the Date Slicer was introduced whereby the Date Slicer had a calendar icon right next to the dates by default. While this feature is designed to meet accessibility requirements, it cannot be customized in the formatting pane. Instead, it can only be customized […]
Toggle Calendar Icon Visibility in Power BI Date Slicer Read More »
In this video, I share my solution to a Power query challenge posted on the Excel BI Linkedin page on 17 Oct 2022. It may seem that the question is simple, but there are some nuances that must be taken into account in order to come up with a robust solution. By combining a variety
Power Query Challenge & Solution | No of Wins by Soccer Teams Read More »
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 »
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. 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 »
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 »
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 »
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 »
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 »
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 »