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 »