This video demonstrates a few powerful techniques to highlight values or data points that are above or below average in a chart, going beyond the built-in reference line functionality in Power BI. Learn how you can apply conditional formatting in a line chart with a simple tweak, and finally, I will build a dynamic average […]
Highlight Above and Below Average in Power BI Read More »
Setting default date filters in Power BI is a challenging task. if you need to filter to a certain date range such as Today, current month, the past 7 days, and so on. I am sharing a technique here on how to achieve it using DAX and Calculation groups. The technique shown here can be
Setting Default Dynamic Date Filters in Power BI Read More »
In this article/video, I am sharing a data visualization technique In Power BI to build an In-page navigation element using bookmarks and buttons to provide a user-friendly experience to navigate within a report page. When building reports in Power BI, it’s important to keep the layout simple and to show only the relevant visuals
How to create an In-Page Navigation with Bookmarks and Buttons in Power BI Read More »
I recently cleared the Exam DA-100: Analyzing Data with Microsoft Power BI. In this article, I share my experience on the preparations, resources that I used, practice questions links, and some important tips. If you plan to attend the DA-100 exam and earn the Microsoft Certified Data Analyst Certification, this article could be a useful read as I share
How I Prepared and Successfully Passed the DA-100 Microsoft Exam Read More »
In this article, I will be sharing a technique using List.Accumulate function to calculate the Exponential Moving Average (EMA) in Power Query. When it comes to recursive operations, the List.Accumulate is indispensable and becomes handy in scenarios of this nature. Read through the blog and download the attached PBIX file to learn more.I will be sharing a solution
Exponential Moving Average in Power Query (EMA) Read More »
I am sure people spend more time and effort cleaning and organizing their data when they need to perform data analysis in Excel, Power BI or any other tool. You do not always receive data in tabular and normalized formats for you to straightaway use the analysis tools like Pivot Tables, Filtering, Chatting and data
Pivot, Unpivot and Transpose Data with Power Query Read More »
Allocating amounts such as contracts, prepayment, revenue, cost, etc. across different date ranges is a common Excel challenge that can be solved in many ways. Let’s assume you have some rent contracts with start date, end date, and the amount which needs to be split into months based on the exact number of days in
Split Amount across Months Using Power Query in Excel and Power BI Read More »
Entering dates in a worksheet confuses most Excel users. Nearly every user has faced a date format problem, which format should be used to enter date? Should we set the month first then day or other way? Which date separator to be used? Is it “/” or “-“? How will the date be parsed when
Popup Calendar Addin for Excel Read More »
Suppose you maintain an Excel workbook to record your income and expenses, and you want to know the current balance of cash in hand or bank balance at any given date. Fowmy AbdulmuttalibFowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald’s
Calculate a Running Balance Read More »
Data validation is a powerful Excel feature that can be used to restrict what data can or should be entered in a cell. You can setup data validation to prevent users from entering invalid data. Fowmy AbdulmuttalibFowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed
Data Validation – Use a Formula to Validate Email Addresses Read More »