Topic: Power BI
-
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
-
This article describes the different approaches to format your DAX measures in Power BI semantic models using custom and dynamic format strings. Read more
-
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
-
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 how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. 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
-
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