Tag Archives: DAX

Best Practices and Essential Tools to Optimize Power BI Reports

Power BI is one of the most powerful business intelligence tools available, enabling organizations to visualize, analyze, and share insights efficiently. However, as your datasets grow and your reports become more complex, performance can degrade, leading to slow report loading times and a frustrating user experience. To ensure your Power BI reports are fast, responsive, and user-friendly, it’s essential to follow optimization best practices and leverage the right tools. In this article, we’ll explore the best strategies and tools for optimizing Power BI reports.

Continue reading →

Power BI Tips: How to Join Two Tables on Multiple Columns

Joining tables in Power BI is a common task when working with data models, especially when your tables don’t have a straightforward one-to-one relationship. Sometimes, you may need to combine two tables using multiple columns as the linking fields. This is where creating a composite key comes in handy.

Continue reading →

Power BI Tips: How to Synchronize Primary and Secondary Y-Axis in Power BI Line Charts

When working with Power BI line charts, you may want to display two data series with different scales using dual Y-axes (primary and secondary Y-axis). However, if the scales don’t match, it can make your chart confusing and potentially misleading. To ensure your data is accurately represented, synchronizing the Y-axes by setting consistent minimum and maximum values is key. This guide will walk you through the steps to synchronize the primary and secondary Y-axes specifically for Power BI line charts.

Continue reading →

Useful Shortcuts for Power BI and Fabric

Power BI is a powerful tool for data visualization and analysis, but navigating through its various features and functionalities can sometimes be time-consuming. To enhance your productivity and make your workflow more efficient, Power BI offers several keyboard shortcuts. Whether you’re cleaning data, building visualizations, or customizing reports, these shortcuts can save you time and effort.

Continue reading →

Well Known Power Query Errors and How to Handle Them

Power Query is a powerful tool used in Power BI, Excel, and other Microsoft products to clean, transform, and load data. While it simplifies data preparation, users often encounter various errors that can disrupt workflows and hinder progress. Understanding these errors and knowing how to resolve them is crucial for any data professional. In this blog post, we will explore some common Power Query errors, their causes, and practical solutions to fix them.

Continue reading →

Power BI Tips: Intro to DAX Studio(DP-600 Exam Content)


I recently took Microsoft’s DP-600 exam/Fabric Analytics Engineer Associate(Twice 1 fail and 1 pass), and I noticed that several questions covered Power BI External tools, such as DAX Studio, and the correct use of DAX statements. Therefore, I think I ought to write a post on DAX studio for those of you who are also interested in taking this test.

Continue reading →

Tableau to Power BI : How to Use Tableau Fixed LOD in Power BI

Leave a reply

If you’ve navigated Tableau’s powerful Level of Detail (LOD) function, you know its complexity and potential for creating impactful visualizations. Now, whether you’re transitioning from Tableau to Power BI or need to excel in both platforms with limited Power BI skills, fear not! In this series, we’ll unravel the mysteries of applying Tableau’s three main LOD functions in Power BI.

Continue reading →

Power BI Tips: Implicit and Explicit Measure

Leave a reply


There are two types of measures in Microsoft Power BI models: implicit and explicit. Implicit measures are automatic and summarize column data in visuals.

Explicit measures, also referred to as just measures, are custom calculations you create for your model. Put simply, implicit measures are columns that can be aggregated automatically, while explicit measures are custom calculations defined using DAX, and is THE measure that we are familiar of.

Continue reading →