This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix.  Read more

This article gives an overview of some of the available tools that can help you create semantic models and reports.  Read more

This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report.  Read more

This article is about a process to use AI tools like LLMs to create custom visuals in Power BI, and how this still requires deliberate thought, planning, and learning.  Read more

Visual calculations are useful for performing calculations specific to a visual. Conditional formatting is a great example of this concept. In this article, we show how to easily implement conditional formatting through visual calculations.  Read more

This article describes an Accounts Receivable Aging report in Power BI, and shows how to simplify a business problem using existing modeling patterns.  Read more

This article is about how rules like “avoid pie charts” can be useful for beginners, but also unhelpful in real-world scenarios with more nuance. Instead of learning rules about “how”, try to understand the “why”.  Read more

This article describes the differences between the ALL and CROSSFILTERED functions in DAX.  Read more

This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total.  Read more