This article explains the roles of the formula engine and of the storage engine used to execute DAX queries.  Read more

A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in detail the KPI settings needed to get the best result using Power BI and…  Read more

This article describes the behavior of the DAX functions that manipulate sets; they are useful to create queries and sometimes also to author measures.  Read more

This article and its companion video describe how to create a service principal account to be used with the Power BI API. The reader must already be familiar with the Power BI API.  Read more

A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order.  Read more

In this article, we share an idea to reduce the friction in using Power BI, by extending the DAX language with new visual calculations.  Read more

This article describes how to optimize a slow Power BI report with a large number of card visuals, by obtaining the same graphical layout with a smaller number of visuals.  Read more

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of using the alternate rows color formatting option.  Read more

This article describes how to control format strings in calculation groups. Before starting, we suggest you read the previous articles in this series.  Read more

COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose conditions, and yet obtain the same result.  Read more