Topic: Power BI
Displaying filter context in Power BI Tooltips
This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips. Read more
Hiding future dates for calculations in DAX
This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. Read more
DAX error messages in Power BI
This article describes the real meaning of and the required action for a few common error messages that can appear when users define DAX expressions in Power BI. Read more
Bidirectional relationships and ambiguity in DAX
Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models as numbers become unpredictable. This article provides a deep explanation of the kind of ambiguity that might appear… Read more
Understanding numeric data type conversions in DAX
This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. Read more
Improving temporal line charts in Power BI with DAX
This article shows how to improve line charts with a date-based X-Axis in Power BI using DAX, and how to make correct choices in the data modeling and visualization properties. Read more
Showing actuals and forecasts in the same chart with Power BI
In budgeting reports, a common requirement is to show future sales forecast and actual sales volume on the same line chart. This article describes how to achieve this goal using DAX. Read more
Displaying Nth Element in DAX
This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties. Read more
Understanding DAX Auto-Exist
This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI. Read more
Optimizing DAX with cardinality estimation: computing working days
Estimating the cardinality of iterators is an important skill when optimizing DAX code. This article explains how to use this technique, evaluating different ways of computing the number of working days between two dates. Read more