Using REMOVEFILTERS in DAX user-defined functions, and news
Don't miss the next newsletter - Subscribe now!
By subscribing, you agree to our Privacy Policy. This site is protected by reCAPTCHA.
NEW ARTICLE
This article describes how to apply a different formatting rule at each level of a hierarchy (one rule at the year level, another at the quarter level, another at the month level) using ISINSCOPE in a measure or ISATLEVEL in a visual calculation.
Read more

 

COMICS
AI BI Blunders
This comic has been generated by Grok and ChatGPT using so many prompts...

 
BLOG POST
After 3 years, we updated the Generative AI guidelines at SQLBI. The world has changed: nowadays, we use generative AI services for a multitude of purposes. While we still continue to produce original (human) content, we are fully transparent on services that have become part of the production process.
Read more

 

BI-WEEKLY NEWS DIGEST
Latest news
• Power BI Desktop Bridge (Preview)
This new feature in preview enables external tools and AI agents to interact with Power BI Desktop: not only by changing the model, but also modifying the reports! The post is technical and shows the API available. Even if you are not a developer, you can understand the possibilities unlocked by this feature, like taking a snapshot of a report in PNG. Your agent can see it. Or you can print it. Win-win.
Jun 30, 2026 · Microsoft
• Deep dive into visual calculations (Generally Available)
To celebrate the official release of visual calculations in Power BI, this article shows the main concepts and tips. Yes, applying the data type to a visual calculation still requires changing the format options. You now have a good reason to use the agent in order to set these hidden properties required to properly use visual calculations in conditional formatting!
Jul 2, 2026 · Microsoft
• Power BI reports vs Fabric Apps
Are Fabric Apps going to replace Power BI reports? We don't think so, and this time we are aligned with the official statement by Microsoft. Reports are not going away anytime soon. But certain reports could be replaced by Fabric Apps, and new possibilities are opened up by this new tool.
Jun 23, 2026 · Microsoft
• Power BI DirectQuery mode: a better choice than you might think
When is it a good idea to use DirectQuery? Make sure to read this piece all the way down to the comments, for interesting conversations about this topic!
Jun 28, 2026 · Chris Webb
• Synoptic Designer 2.0 is now available
Synoptic Designer 2.0 is a redesigned browser-based tool for creating custom maps for Synoptic Panel in Power BI. Start from an image, floor plan, or technical drawing, define areas, use the improved Magic Wand, match areas to your data, and export a JSVG map ready for use. Yeah, this is advertising, but the tool is really cool!
Jul 9, 2026 · OKVIZ


Data Modeling for Power BI

SQLBI YOUTUBE CHANNEL
Latest videos
Using REMOVEFILTERS in DAX user defined functions
14:11#announcementMarco Russo
Optional parameters in DAX user defined functions
16:01#articleMarco Russo
ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS
18:45#articleAlberto Ferrari
Introducing DAX Lib
06:22#articleMarco Russo
Employee workstations with Synoptic Panel by OKVIZ
02:10#customvisualMarco Russo
Introducing DAX Optimizer Basic
07:30#articleMarco Russo