Articles of 2024
Improving data labels with format strings
This article describes the different approaches to format your DAX measures in Power BI semantic models using custom and dynamic format strings. Read more
Building bullet charts in Power BI reports
This article is about how to read and use bullet charts when comparing actuals to a target in Power BI, and the different options you have available to make these charts in Power BI reports. Read more
Re-using visual formatting in and across Power BI reports
This article is about how you can save time when building and maintaining Power BI reports by using strategies to re-use visual formatting. Read more
Blank in date columns and DAX time intelligence functions
This article explores the implications of having blank values in date columns and provides the best practices for managing them in DAX calculations and Power BI reports. Read more
Computing open orders with visual calculations in DAX
This article describes the use of visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period. Read more
Using weekly calendars in Power BI
This article describes why week-based calendars (like 4-4-5) are important for specific industries and how to use them effectively in Power BI. Read more
Impact of data types in DAX arithmetical calculations
The choice of data types can affect precision and performance because of internal conversions. This article shows how the right choice of data type and DAX code makes a significant difference. Read more
Creating custom visuals in Power BI with DAX
This article is about creating dynamic images in DAX measures to visualize data in tables or cards, including an easy way to do this in Figma, and a caution for using these DAX measures in real-life scenarios. Read more
Context transition in DAX explained visually
This article describes the DAX context transition using a conceptual model based on a visual representation. Read more
Filter columns, not tables, in DAX
One of the few golden rules in DAX is to always filter columns and never filter tables with CALCULATE. This article explains the rationale behind the rule. Read more