The March 2021 update of Power BI Desktop has been released. There are quite a few neat features released this month, I'll highlight just a few of them here. Read all the feature updates in the official Microsoft Power BI blog.
DAX Updates
DAX users will love this month's update. The CALCULATE function has been updated to be more flexible, now allowing you to filter multiple columns in the same DAX expression. And just when I thought I had mastered DAX! But seriously, this is a handy feature and a good reminder that all CALCULATE functions written with a single column boolean expression, such as:
Red Sales =
CALCULATE (
[Total Sales],
Product[Color] = "Red"
)
Are actually evaluated as:
Red Sales =
CALCULATE (
[Total Sales],
FILTER (
ALL ( Product[Color] ),
Product[Color] = "Red"
)
)
Comicgen visual named Editor's Picks Visuals of the Month
I highlighted the Comicgen visual in my 12 Days of Christmas blog series and this month it has made the list of Editor's Picks for Visuals of the Month. Let's see if it gains momentum and brings more insight and storytelling to the reporting world.
Your Turn
Enjoy the March update and let me know what some of your favorite features are.
