When it comes to streamlining your Power BI data modeling, the value of automation cannot be overstated. One of the most powerful tools available to achieve this automation is Tabular Editor, where you can write C# scripts to optimize and automate repetitive tasks. In this blog post, I’ll introduce you to my Power BI ToolboxContinue reading “My Power BI Toolbox: 80+ Tabular Editor Macros to Automate Data Model Development”
Tag Archives: power-bi
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: No2. The Lonely Fighter
Okay this is not exactly a poor Power BI report or mistake per se, but might be just one contributing factor for your “poor Power BI report”. Have you learned your Power BI skills mostly by yourself via YouTube, reading through the endless Microsoft documentation, or some “secret blog article” like mine? 😉 Here isContinue reading “Spot Poor Power BI Reports: No2. The Lonely Fighter”
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”
Power BI – Pimp – Script
Do you would like to apply data model best practices with a click of a button to your existing Power BI reports? Than the “PBI-Pimp-Script” is the right place for you! Edit: This script had a major revamp, published on 31. January 2024 and includes now a lot more: Explicit Measure Creation, Units calc group,Continue reading “Power BI – Pimp – Script”
Blog about Actionable Reporting - Alexander Korn 