9 Tiny but Super Useful Power BI Hacks

In this video, will be sharing 9 small yet highly useful Power BI hacks that will help you optimize your Power Query, DAX, and visualizations. We'll cover 3 hacks each for Power Query, DAX, and visualizations. Let's dive right in!

In the Power Query section, we will learn how to easily track data for a specific row, find columns in a large table, and filter values effortlessly.

Moving on to DAX, we will discover tricks to format our visualizations effectively and filter data in one-to-many relationships using expanded tables.

Lastly, in the visualizations section, we will explore tips for enhancing the quality of tables, resizing columns efficiently, and locking objects to prevent accidental movement.
#powerbi #dataanalysis #visualization

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[matthewpage]

These are so helpful I know I'm going to need to revisit some so here's the content shortcuts

Power Query:

0:28 See the row
1:07 Find the Column (Ctrl+G)
1:40 FIlter by select rClick

DAX
===
2:15 Visual line break
3:25 Filter from the fact table (Calc + Table)
5:40 Maxx for Max of 3 measures

Visuals

8:04 Padding
9:00 Resizing columns using Shift + arrows
9:45 Lock objects

[bradj]

That MAXX with the 3 measures and using default Value column was awesome!

[williamarthur]

Loved the last one for a pseudo table, don't think I've seen it before but looks really useful.

[learntech]

reverse filtering and pseudo table trick was awesome, thanks man!

[rohanbhattacharyya]

The reverse filtering will be really helpful.!

[evelic]

These tricks truly make life easier. Thanks.

[Henrik.Vestergaard]

Weltklasse! Valuable DAX - and even See the row and Resize columns was awesome...

[antoniogarrido]

Awesome..! simply but useful tricks.. Thanks Chandeep 👍

[IvanCortinas_ES]

Wise advice and excellent improvements in the functionality of our work. Thank you!!

[elcoxeroni]

Sir, your videos are outstanding!!! Wish to have found your channel earlier in my Power BI journey. Best regards from Germany

[roycemekolle]

The first 2 Power query tricks were awesome

[kdausu]

Amazing. I absolutely love your channel.

[praveenkumar_]

Excellent Hacks and got to know some new hacks especially in Power Query😍😍

[benndii]

Understanding DAX in its depths is sometimes not too easy for me. As always, your tricks help me to get better. A big Thank You!

[hariprasad]

DAX tricks are super awesome, thank you so much

[reddragonduke]

5:14

For better performance use Keepfilters(fact table) instead of just fact table

[KgTechTravel]

You nailed it everything. Mindblowing!!

[arbazahmad]

Dax no. 3 trick is awesome 👌... thanks 😊

[vikrantheswar]

Great tricks. Keep posting such tricks frequently ❤. Life gets easier with your tricks.

[sanumpzha]

That pseudo table part was great Chandeep.. Nice content as always! 🤟Loved it.
The tip about the Lock Object had already been shared on some previous days' tips😁😁