Tag Archives: dax

Spot Poor Power BI Reports: No4. No “EMPTY MEASURE TABLE” 

When building Power BI reports, deciding where to place your measures—whether in a dedicated measure table or directly in the fact table—can impact both usability and maintainability. Here’s a look at why creating a separate measure table often works best and why it’s becoming a popular approach for Power BI developers and report consumers alike.Continue reading “Spot Poor Power BI Reports: No4. No “EMPTY MEASURE TABLE” “

Spot Poor Power BI Reports: No3. No Units Calculation Group

When working with large datasets in Power BI, displaying big numbers—especially those over a million—can become a challenge. Lengthy figures not only clutter your visuals but can also confuse your audience. To enhance readability and comprehension, it’s essential to format these numbers into thousands, millions, or even billions. While Power BI offers several methods toContinue reading “Spot Poor Power BI Reports: No3. No Units Calculation Group”

Spot Poor Power BI Reports! No1: The Slicer Mess

This article is part of a series on how to spot a poor Power BI report. There are many pitfalls, which are obvious like 3D Pie Charts, but then there are others which are less obvious. We all have done those mistakes, we actually all of us make some of those still every day, awareContinue reading “Spot Poor Power BI Reports! No1: The Slicer Mess”