Chandeep Chhabra (@chandeep2786) 's Twitter Profile
Chandeep Chhabra

@chandeep2786

Excel & Power BI consultant and content creator. Beware if you follow me - I rant occasionally.

ID: 74962733

linkhttps://youtube.com/c/GoodlyChandeep calendar_today17-09-2009 08:03:44

1,1K Tweet

5,5K Takipçi

45 Takip Edilen

Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

One thing you can do to instantly improve your tables in Power BI. (And it’s not that hard 😍) I’m talking about customizing the Totals row. If you’ve ever tried it, you know how limited Power BI can be. You can change the font, color, maybe the size… But not what it shows -

Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

how to become an irreplaceable #dataanalyst.🧵 start doing the hard things that no one else does. let me explain. 1️⃣ learn the business - bi tools are commodities, but a great analyst can read financial statements, MD&A sections of an annual report, and industry reports. your

Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

here is thing about #visulizations do analysis first then design. always. I'll explain - you start building a dashboard and the first thing you think about is design - figma layout, theme etc.. you're doomed - because you'll be thinking about chart colors, shadows, shades,

Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

Unlocking Sales vs Delivery Insights with Smart Data Modeling 📊 Ever wondered how to track not just when sales happen, but when they actually get delivered? Here's a powerful data modeling technique that transformed how we analyze sales performance: The Setup - We have a

Unlocking Sales vs Delivery Insights with Smart Data Modeling 📊

Ever wondered how to track not just when sales happen, but when they actually get delivered?

Here's a powerful data modeling technique that transformed how we analyze sales performance:

The Setup - 
We have a
Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

How to make your Power Query Case Insensitive 🤔 The Compare Case enumeration (keyword) is available for - - Text.Contains - Text.StartsWith - Text.EndsWith - And a few others #Mjoy #PowerQuery

Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

Context Transition in Power BI Three similar-looking formulas. Three completely different mechanisms. Let me break it down 🛠️ 📅 Example 1: Best Selling Day We have an existing Calendar table in our data model. Since it's structured at the day level, MAXX iterates through

Context Transition in Power BI 
Three similar-looking formulas. 
Three completely different mechanisms. 
Let me break it down 🛠️

📅 Example 1: Best Selling Day
We have an existing Calendar table in our data model. Since it's structured at the day level, MAXX iterates through
Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

🎉 Power BI Just Made Our Lives Easier Remember those annoying "Column Not Found" errors that broke your entire data refresh? Yeah, those days are (mostly) over. 😑 The Problem - You've built a beautiful Power Query transformation. Everything works perfectly. Then one day, a

🎉 Power BI Just Made Our Lives Easier
Remember those annoying "Column Not Found" errors that broke your entire data refresh? 
Yeah, those days are (mostly) over.

😑 The Problem - 
You've built a beautiful Power Query transformation. 
Everything works perfectly. 
Then one day, a
Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

The usual hide/unhide trick is too basic... But here’s how you can completely hide it so no one can unhide it easily 👇 Have you tried this feature in hashtag#Excel before?

Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

Happy Diwali! Wishing you fast data refreshes, spot-on measure totals, and zero change requests. May this Diwali bring you healthy star schemas. #HappyDiwali

Happy Diwali! Wishing you fast data refreshes, spot-on measure totals, and zero change requests. 

May this Diwali bring you healthy star schemas.

#HappyDiwali
Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

I use this Framework to present my PBI projects (and win high-value clients) A lot of analysts start their presentations like this - “This dashboard has 19 visuals, 4 data sources, and custom DAX measures.” That’s not how you impress decision-makers. Because leaders don’t care

I use this Framework to present my PBI projects (and win high-value clients)

A lot of analysts start their presentations like this -
“This dashboard has 19 visuals, 4 data sources, and custom DAX measures.”

That’s not how you impress decision-makers.
Because leaders don’t care
Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

Did you know about this DAX function? When you use CALCULATE, it gives priority to the filter inside the formula and ignores the one coming from the visual. That’s why Affiliate Sales end up showing for every row, even where they don’t belong. But when you wrap that filter

Chandeep Chhabra (@chandeep2786) 's Twitter Profile Photo

Don’t add another step for headers. Change null to true in Excel.Workbook and Power Query promote headers automatically ✅ {M}joy!