After years in “stealth mode,” we’re excited to introduce DAX Optimizer. Dive deeper here: https://t.co/P5P9F9vOvH DAX Optimizer is a tool – delivered as a service – that helps identify potential bottlenecks and suggests impactful solutions and priorities. You still write the

Too many items in your slicer? Users getting lost? Sometimes a hierarchical slicer helps. But if your values come from different tables, or from a calculation group, things get tricky fast. In this video, Alberto shares a few practical DAX techniques to reduce what's shown in

Only 3 in 10 Veterans know about 0% down home loans. Join our mission to help veterans find their way home.

Just delivered my slot at Power Hour session at #passdatasummit Thank you all for attending!

If you are at PASS Summit 2025, look for me at the Tabular Editor booth in the Exhibit Hall. I will show a sneak preview of DAX Optimizer basic edition: no emails, no data access, no external tools required. The easiest way to verify if your semantic model can be optimized.

Learn the differences between model-dependent and model-independent DAX user-defined functions in this article+video. Bonus: naming conventions and guidance to avoid hidden dependencies to publish libraries of functions on https://t.co/FmUVZWH8z5. #dax #powerbi

Microsoft loves acronyms… so much that “UDF” now has multiple personalities in Power BI and Fabric. Do you know what UDF stands for?  Wrong answers only (it’s Saturday). Comics from SQLBI Newsletter: https://t.co/nRekNZ1SG3

Want your DAX measures to change format based on context? Dynamic format strings let you control number formatting using DAX expressions, based on a value, a table, or a user selection. In this video, Alberto shows how the feature works, how to enable it, and what to keep in

This video presents a real-world use case of the Synoptic Panel visual in Power BI. In this example, we explore how to 𝘃𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗲 𝗮𝗻𝗱 𝗮𝗻𝗮𝗹𝘆𝘇𝗲 𝘁𝗶𝗰𝗸𝗲𝘁 𝘀𝗮𝗹𝗲𝘀 𝗮𝗻𝗱 𝘀𝗲𝗮𝘁 𝗼𝗰𝗰𝘂𝗽𝗮𝗻𝗰𝘆 in a large venue, The Sphere in Las Vegas, using a custom

If your DAX measure is slow or gives the wrong numbers, this might be the reason ↓ One of the few hard rules in DAX: Filter columns. Never filter tables. It seems like a detail, but it affects both performance and accuracy. In this video, Alberto shows what can go wrong when

Top 10 products are a classic. Reporting which products are in the top 10 for several years is more challenging. We are looking for 𝗲𝘃𝗲𝗿𝗴𝗿𝗲𝗲𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀: how to find them in DAX in this article+video. #powerbi #dax https://t.co/IrvpnK4sxl

We never really told you why we started publishing the comic strip "AI BI Blunders". A few months ago, we just began dropping these comic strips into our newsletter, no explanation, no announcement. Some of you noticed, and many seemed to enjoy them. The truth is, we’d been

Amazing session by Victor Rivas about Synoptic Panel at #tconf2025

The conference starts - so many people in Lugano today! #tconf2025

FYI: You can refresh your model or tables in Power BI Desktop from Tabular Editor 3, now. While this refresh is happening, you can continue working in Tabular Editor 3 OR Power BI Desktop, uninterrupted. You can monitor the refresh progress and cancel it from TE3, too.

The DAX Package Manager (in Tabular Editor 3) is now the benchmark for future implementations of DAX Library integration in other external tools. It's so fast that I thought it didn't work when I installed the first library. Kudos to the TE3 team! #powerbi #dax

Creating a mouth visual with Synoptic Panel in #powerbi ! This is the first video in a series about the many use cases published on the OKVIZ website. 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗖𝗮𝘀𝗲 𝗦𝘁𝘂𝗱𝘆 https://t.co/tPehNzkk3o 𝗧𝗿𝘆 𝗦𝘆𝗻𝗼𝗽𝘁𝗶𝗰 𝗣𝗮𝗻𝗲𝗹 https://t.co/PeKMlVmjez

Sunday reminder for those of you attending @PASSDataSummit 2025 in Seattle. I'll deliver "Advanced DAX Techniques" precon on November 18, 2025. Full day. Intense. The only good news is that it's on Tuesday, so that you can start your week on Monday with something less demanding!

I start to believe that one of the biggest misconceptions in data analytics is that dimensional modeling is for the data warehouse, whereas it is really for the data mart. Someone should fix that.

Today you have one task: update DAX Studio to 3.4.0. If you have a model with DAX UDFs (user-defined functions) or Calendars, here is the version that correctly handles autocompletion and VPAX export. 𝗘𝘅𝗽𝗼𝗿𝘁 𝘁𝗼 𝗣𝗮𝗿𝗾𝘂𝗲𝘁? Now you can! https://t.co/tCn5Xi5a4D

If you’ve ever needed to sync the Y-axis across multiple charts in Power BI, this video shows how to do it correctly with DAX. Alberto begins with simple examples and gradually builds up to a more advanced case, where the axis is calculated dynamically based on the selected