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
Expanded Tables - www.sqlbi.com/articles/expand...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/small-useful-pow...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== 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!

[@matthewpage4706]

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

[@elcoxeroni8273]

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

[@karishmagupta6297]

You nailed it everything. Mindblowing!!

[@gkirankumarskht]

Reverse Filtering is awesome

[@reddragonduke]

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

[@isidreb]

Absolutely great!!. Thanks for sharing

[@captivatedCoder]

The column resize trick is SO good!

[@GoodlyChandeep]

Thanks :)

[@kdausu90]

Amazing. I absolutely love your channel.

[@evelic]

These tricks truly make life easier. Thanks.

[@Henrik.Vestergaard]

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

[@learntech5183]

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

[@bradj229]

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

[@IvanCortinas_ES]

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

[@yogirajoo]

Very good tips ! Many thanks !!

[@ashirwadpatil6838]

Helpful tip, Thanks

[@dilipinamdarpatil6301]

Thank u very much 🙏!!!!!! Useful info

[@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😁😁

[@mnowako]

There is always something new, amazing and useful in your videos. Thanks a lot!

[@saniyanulkar9093]

Amazing tricks!!

[@rohanbhattacharyya6600]

The reverse filtering will be really helpful.!

[@taizoondean689]

Thank you 😊

[@user-ef4oc3vc6r]

Cool! Thank you.

[@williamarthur4801]

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

[@hariprasad289]

DAX tricks are super awesome, thank you so much

[@venkatagiriprasad9149]

Awesome sir🎉❤ thank you

[@ragragrec1]

nice tips man, thanks

[@siddheshamrutkar8684]

Super Duper Awesome..

[@mirrrvelll5164]

Always amazing tricks! That PQ second trick and DAX (MAXX) trick really bananas!! We are waiting you Power Query Master class 🤘

[@arbazahmad7177]

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

[@roycemekolle7334]

The first 2 Power query tricks were awesome

[@mogarrett3045]

excellent tutorial brotha

[@aditir1158]

Super!!

[@lingambalakrishna]

Simply superb

[@ymohamed3154]

Perfect 👌

[@antoniogarrido3058]

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

[@GoodlyChandeep]

Thanks Antonio :)

[@emilmubarakshin49]

great tricks - especially there expanded tables. I literally just used it today - had to go a few tries before I got it right :)

[@GoodlyChandeep]

Well done!

[@user-yo2nb4ry7i]

хорошая рубрика. Удачи.

[@cathrerinezetadrones3169]

Sudo tables are great!

[@ashirwadpatil6838]

Great,

[@kohkombero]

Nice tips overall! I feel embarrassed, but I have been struggling with reverse filtering in several cases and haven't been using a consistent method to bypass that limitation properly. So big thanks for DAX trick #2 and getting to understand the concept behind that.

[@mohamedmossad9458]

Neat tricks. I enjoy it. Can you share more context about using Column Reference as a filter argument for CALCULATE Function.

[@praveenkumar_0143]

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

[@GoodlyChandeep]

Thanks Praveen

[@josealvesferreira1683]

very good

[@vikrantheswar7685]

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

[@GoodlyChandeep]

Sure, I will. :)

[@fasamcat]

Goodly always has good stuff and this is no exception

[@waleedalhasan85]

Awesome

[@ramrn8988]

Maxx is really awesome 👍

[@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!

[@GoodlyChandeep]

Happy to help :)

[@yarimagoni2800]

​@@GoodlyChandeepI have a question sir on power query

[@richardmartin7904]

Pure gold and so much frustration can be avoided now.

[@GoodlyChandeep]

😂

[@CatLover-kr1zb]

Unfortunately, I am in Iran and do not have the possibility to obtain your wonderful course.😢

[@itikshamittal]

Amazing tricks, today itself I was working on matrix and there's the task to increase the width of columns , shift left and right key works wonder!

[@GoodlyChandeep]

Thanks Itiksha :)

[@jishnusachidanandan5866]

pseudo table part is a fantastic hack

[@nirmitshah6162]

Dax king.... ❤️

[@GoodlyChandeep]

Cheers Nirmit :)

[@andrewdutch4843]

'mazing!!

[@jonahjohnbaba]

Can DAX measures be locked? So that someone doesn't delete or change it?

[@marivicmawanay3246]

How do you resolve "File contains corrupted data"

[@user-gm4sq4og9i]

Like to contact you personally to get to know about power BI training.

[@Everythingexcelpro]

Can we use power bi without registration

[@GoodlyChandeep]

Yes, you can, but there are some limitations.

[@bulbulahmed3098]

❤❤

[@user-fy3ew6fy9q]

Some pure nuggets there, thanks Chandeep!!! Just wish I could set column width similar to excel and choosing multiple columns to set width. I'm aware of the measure method with x 0's for example, but that doesn't seem to work if my matrix table consists of multiple measures to populate the values. 😢

[@julie_chen]

All banana 🎉🎉🎉

[@jerrydellasala7643]

Ummm... Missing from Download file: Sales - "D:\OneDrive - Goodly\Online Trainings\Power BI - Pidilite\DAX and Modeling\Data.xlsx" Products - "D:\OneDrive - Goodly\Online Trainings\Power BI - Pidilite\DAX and Modeling\Data.xlsx"

[@GoodlyChandeep]

goodly.co.in/wp-content/uploads/2023/08/9-Power-BI-Tricks.zip