-
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
-
As one of the founders of OKVIZ—a company dedicated to producing custom visuals—I have been following the recent developments in Power BI Desktop with particular concern. This issue, however, extends beyond our company and affects many other organizations that rely… 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
-
After another year, it is time to recap what happened in the DAX and SQLBI worlds and provide a few spoilers about 2025! Read more
-
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
-
We released more content in SQLBI+ with two new sessions: Introducing Visual Calculations in Power BI: This two-hour session introduces the Visual Calculations feature in Power BI, which is still in preview. We plan to update the “Understanding Visual Calculations… Read more
-
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