Tag Archives: DAX

How to Synchronize Primary and Secondary Y-Axis in Power BI dailybitalks.com

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 dailybitalks.com

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 →
Common Power Query Errors and How to Handle Them dailybitalks.com

Common 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 →
dailybitalks.com Microsoft Fabric PowerBI

Power BI Tips: Great 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 →
DailyBITalks Tableau Fixed LOD

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

Power BI Tips: What are Implicit and Explicit Measures?

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 →
Tableau to Power BI --- How to Convert If/Else to Dax Switch Function

Tableau to Power BI — How to Convert If/Else to Dax Switch Function

Leave a reply

If/esleif/else is one of the the most used functions in Tableau calculation and unfortunately, it can not be applied verbatim in Power BI to achieve the same goal. The equivalent function in Power BI DAX language is the Switch() function and it works especially well on multiple scenarios, it can be used to convert either if/elseif/else statement of possibly case/when query in Tableau.

Continue reading →