explore | Grilled Cheese

568 - Microsoft shows up dead last to every category. Tableau landed first and everyone loved it, then Power BI came along cheaper and, my opinion, passed it. Fabric is running the same play.

youtu.be/8Jn9ttXXSs0

#powerbi #microsoftfabric #tableau #bitools

#PowerQuery doesn't have a great concept of row context, making it very difficult to compare values across rows. 🔢 In this Monkey Shorts, @excelguru.ca demos a super-cool black magic technique that allows you to do exactly that. 😈 www.youtube.com/watch?v=zdNY...

#Excel #PowerBI #DataAnalytics

Today's Vancouver #PowerBI and Modern #Excel meet-up gets underway at 5pm PT. @wynhopkins.bsky.social will lead a fast-paced, practical session demo'ing high-impact Excel tips that will help you take your game to the next level. ✨
Sign up here to join us: www.meetup.com/vancouver-po...

Not every Power BI calculation belongs in a column.
Columns are stored row by row; measures respond to report filters. For totals, ratios and KPIs, a measure is often the better choice.
Choose according to how the result should behave.
#PowerBI

Fabricated references in AI-written papers. Coding errors that keep coming back to hallucination. It is not just a memory problem, but that compounds it: every query starts fresh, plausible is not true.
Deploy your local AI properly. That is the difference.
youtu.be/wIg-tdj7hv8
#PowerBI #LocalAI

Don’t add a single DAX measure before you read that ⬇️

#powerbi #DAX #measures #data

Would you pass the PL-300 test?

Find out with our Power BI Knowledge Check: a free 10-minute assessment .

Once you're done you get an instant gap analysis showing where you're strong and which topics deserve more attention.

➡️ Test yourself - Link below!

#powerbi #pl300 #data #analytics

Most Power BI reports don't fail because of bad data - they fail for one of these 4 reasons ⬇️

Sound familiar? Get in touch - link in the comments

#powerbi #consulting #data #analytics

How to set conditional formatting for Power BI metrics with only one calculation group #data #dataanalytics #powerbi #conditionalformatting #daxformatting

TIL the [AlternateResult] arg in SELECTEDVALUE() returns BLANK and not [AlternateResult] if a user has selected everything in the #PowerBI slicer who's column you are referencing.

You need a COALESCE to catch this.

=COALESCE ( SELECTEDVALUE ( SomeTable[SomeColumn], "FOOBAR" ), "FOOBAR" )

Trying to work out if it is possible to create "Analyze in Excel" templates based on #PowerBI semantic model that has RLS kick in in BEFORE the user views the file, and it seems the answer is "no". i.e. any user will see a "snapshot" of all the data until they enable content.

Here's your #PowerBI #Wow2026 challenge for the week from Santhana Lakshmi Ponnurasan: Recreate the Warming Stripes chart using a native column chart
Give it a try! www.workout-wednesday.com/2026-week-41...