10 Power BI Tips for Better Dashboards | Are you using these in your Power BI reports?

👉 Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-tips-po...
Join me in this video where I share 10 valuable tips and techniques to enhance your Microsoft Power BI reports. From formatting and organizing to boosting productivity, this video is a must-watch for anyone keen to refine their Power BI skills.
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
⭐ If you're ready to become a Power BI Pro, join our "Fast Track with Power BI" 👉 www.xelplus.com/course/fast-t...
Key Highlights:
▪️ Conditional Formatting: Learn how to apply different colors to chart values based on their nature.
▪️ Aligning Objects: Tips for neatly aligning and distributing objects on your dashboard.
▪️ Measure Organization: Create a dedicated table for better measure management.
▪️ Folder Structuring: Organize measures into folders for ease of access.
▪️ Custom Backgrounds: Use PowerPoint to create custom backgrounds for a standout dashboard.
▪️ Tooltips Customization: Enhance the information displayed with customized tooltips.
▪️ Page Navigation: Add a page navigator for easy movement between report pages.
▪️ Back Button Feature: Incorporate a back button for efficient navigation.
▪️ Locking Objects: Secure your dashboard layout by locking objects in place.
▪️ PDF Export: Convert your Power BI report into a comprehensive PDF document.
In this video you'll learn the 10 best tips to create effective and beautiful Microsoft Power BI Dashboards. We're going to cover techniques for formatting, organizing, and productivity for Power BI desktop. We'll cover tips like - creating a separate measures table in Power BI, Conditionally formatting charts, adding page navigation (similar to a table of contents), using custom images in your power BI dashboard to make it look more professional, aligning objects, customizing tooltips and more.... let me know if you knew all of these or if you found something new here!
00:00 Power BI Dashboard Tips and Tricks
00:21 Conditional Formatting of Charts
01:39 Align Objects
02:39 Create Dedicated Measures Table
04:23 Organize Measures in Folders
05:07 Use Custom Images for Page Background
06:53 Customize Tooltips
09:39 Add Page Navigation
10:45 Back Button for Easier Navigation
11:18 Lock Objects in Place
11:47 Save BI Report as PDF
12:22 Wrap Up
🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com/
⯆ Detailed written post on 10 Best Power BI tips: www.xelplus.com/power-bi-tips...
🎬 LINKS to related videos:
- How to Use Power BI: • Power BI Tutorial For ...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerbi

[@LeilaGharani]

Loved these tips? Learn Power BI from scratch with our FREE QuickStart course: link.xelplus.com/yt-c-tips-powerbi-freecourse and if you're ready to become a Power BI Pro, dive into our "Fast Track with Power BI" course: link.xelplus.com/yt-c-tips-powerbi-course

[@justingill9822]

For generating to pdf, is there a way to customise the report by adding elements such as header and footer and probably a table of contents and even maybe a page for some paragraph or details?

[@alphamal1987]

Can I pass the pl300 Certification using this course?

[@leewarps]

Waiting for your full Power BI course since over a year now. No any other tutors could provide the inspiration that you do when you teach. You're a blessing. More power to you.

[@mathijs9365]

There are lots of good free courses on YT.

[@lucia26]

Either Leila or Chandoo, love them both!

[@LifeofBusinessAnalystLoBA]

There are many , you need to search ..

[@riccardoczech6195]

Same! The others on udemy are not as clear as Leila’s. @Leila: pretty please?

[@bakthapuri]

I do agree.. @Leila can you please make it for us..??

[@judyl.7811]

1:40 #2 tip: align object. 2:40 #3 tip: organize measures. 2:55 dummy table. 4:25 #4 tip: organize with folders 5:10 #5 tip: custom images. 5:40 save as PNG file 6:30 Image fit 6:35 I don't want to have this white background. 8:35 add filter to the table. 6:55 customize the tooltips. 7:25 when you hover the bar charts, you get the additional data. 9:40 as I hover different group, it shows my choice: Top 5 9:45 #7 page navigation 10:50 #8 back button 11:20 #9 lock objects: all select - Ctrl A and view 11:50 #10 create PDF:

[@swake1822]

My best tip for making dashboards is add a background colour, only needs to be 60-80% transparency, add it to the report page right at the very start of the process and then remove or change when complete, it helps so much for visibility of where your visual's edges are as they all have natural whitespace at the edges. I do this every time I create a new page. Also for big report packs, keep it similar, not just fonts, colours and sizes but the 'grid' you're working on, it makes it much easier on the eye. Good top 10 here though Leila. 👍

[@LeilaGharani]

I like that! Thanks for sharing.

[@idakwiatkowska2862]

There is an option to give the visuals a frame.

[@pantomima5841]

@S Wake I am new to Power BI. Could you please give any link for this tip? I mean as a tutorial or teaching.

[@LeilaGharani]

I hope you found this useful. Which one of the tips are you currently using in your reports?

[@hansklein3649]

I use them all as a package to show my boss that education is more important then making money.

[@juniorakotshi2132]

Thank you so much :-)

[@yassirkhalid5376]

Almost all! The good thing about this video is that a new Power BI course is under cooking!! Done with your DAX course and looking forward to the new one...

[@unnikrishnansanthosh]

currently using back button and tool tips, thank you very much for sharing the tips

[@theweeklychart]

All of them. Thanks for sharing.

[@cryptidcage3615]

Thank you for saving me me AGAIN! Getting data loaded into Power BI wasn't hard but formatting the dashboard is not as easy as one would think.

[@Isaactibenkana]

Leila, you always provide amazing tips in an easy-to-understand format. Thank you for teaching the world.

[@manojraghavan1490]

In just 10 minutes I learnt so many new hidden things! Thanks Leila.

[@reynaldomorillo4271]

Leila, your instructions are concise and to the point. Thank you!

[@marianhymiel2211]

You are the best tutor for power BI so far. I am new to power BI and I am so lucky to found your channel. I admire you so much Leila. I started following you since then.

[@aniljaggarwal60]

Please, keep giving useful tips of power bi like this, then everyone will be benefited. Power bi learners will always be indebted to you.

[@kejmil1992]

I knew all of them before, but it takes me a lot of time to get to know them by experience. Your movie covered it in 12 minutes! You are doing a great job, thank you, Leila! :)

[@isaacmwabila5830]

Your explanations are always easy to understand! Thank you Leila!👍🏾

[@marce_f]

The tips are very very useful, but I recommend to create the background in SVG, not in PNG, because if you do zoom, you will lose image quality.

[@osPA78]

Doing the Top 5 tooltip was a WOW factor for me. Thank you so much!

[@manavmitu]

This is so amazing, i have developed HR dashboard for my organization and my HRBPs are loving it .. power bi creates magic .. your tips are so awesome,this will surely help me to make it more better ... Thanks a ton

[@MoeBig50]

One of my favorite Power BI videos

[@sarahalachewe3205]

Smart and easy teaching. Thanks for this

[@vijayarjunwadkar]

Nice tips Leila! Looking forward to more videos on Power BI, bringing the same expertise and knowledge as your Excel videos! Thank you! 😊👍

[@LeilaGharani]

I'll try my best, Vijay 😊

[@kunjal96]

Wonderful Video leila!!!Thnaks

[@dp6736]

This is amazing. Thanks for sharing. Very nice sweet, short, and 'to-the-point' presentations.

[@chrism9037]

Super useful Leila. I definitely need to spend more time in Power BI to bring my skills on par with my Excel skills. Thanks!

[@LifeofBusinessAnalystLoBA]

There are lot of resources available online ..

[@vishwanath1810]

Excellent tips, thanks!! As usual, crystal clear explanations with extremely relatable illustrations....! As for me, found the Tooltip customization, page navigation and organization of measures incredibly useful.....yes, have started using those in my reports!! Thanks again, Leila!!

[@soueujackson9723]

A way to improve my power bi skills in English!!awesome❤️❤️❤️👏👏

[@xZxeclipsexZx]

The tips 6 is amazing ! Thank you !!

[@karimvazirinejad9883]

Dear Leila, I really congratulate you. Your videos are great. It conveys the most information in the shortest possible time and does not contain extraneous and irrelevant information. Their visual effects are also excellent. I wish you more and more success.

[@alinick4137]

Many thanks for your wonderful video, awaiting for your comprehensive course.

[@tommasogerbino6291]

Thanks Leila - Excellent!

[@imeshseepersad]

Really Helpful! Thank you!

[@kamelgameel1250]

Thanks Leila, appreciated,,, way appreciated You are the best truly

[@rohitwaradpande2492]

Very Useful Tips... Thanks for Sharing...

[@shivareddy7899]

Waiting for more wonderful video's like this !!!!!

[@joaquinmaverick82]

The page navigation buttons are new to me, thanks for the tips!!

[@AccessAnalytic]

All good tips Leila. I'm a fan of dragging measures between tables and folders in the model view, and I like your Select Measures tip

[@ManaviVideos]

Thanks for sharing valuable content!!

[@zhin4362]

A few that I wasn't aware of. Thank you!

[@xoundful]

Awesome! Align objects and customize tooltips would be super helpful for me. Thank you.

[@eaaeeeea]

Very glad to see you've moved to Power BI videos! That's the program I've wanted to learn for years but haven't had a personal project to start learning. Now I'm building a personal finance dashboard in Excel, but I'll definitely move to Power BI soon. I'll then have your lovely videos to guide me :)

[@cheryldavis9797]

Thank you for doing this video! I love how you always provide the real-life examples, not just how it works. I have 2 questions: 1. Are you going to be creating a PowerBI course? I use it a lot and have taken some courses, but I know I'd understand it better if you Leilaized it. 🙂 2. Is it possible to insert a widget from html code into a PowerBI report? I've found the html add-ins, but just can't figure out how to make it work. I did get the word "URL" to show up once. 😞 Thank you again for all the work you do and your courses. I've learned so much and I'm so much better at my job because of you!

[@arjundev4908]

Leila you are god send.. thanks a lot!!!

[@PGOManc7]

Leila! You are again making a real impact! These tutorials are invaluable! And as always....the most beautiful woman on KZbin 😍

[@samadaspt5635]

Leila gharani .. its been 3 years, i began learning from your videos, lots of love from PAKISTAN, looking forward for more videos on POWER BI

[@mayaabd1248]

I loved the tooltip tip, can't wait to use it ! Thank you Leila 🙏🏼

[@LifeofBusinessAnalystLoBA]

Tool tip can come handy when you have to present lot of data ..

[@carneypwr]

Amazing. I love the way you teach.

[@raquelmalonzo5356]

Wow! amazing tips. Thanks Leila 🧡 Im trying them now. Hoping for more BI posts ie about measures. God bless. 🙏🏼

[@shatakshiagrawal3062]

Thank you so much Leila for these tips. 🎉🥰❤️

[@FaysalEasyExcel]

excellent work done lelia. thanks.

[@Heyits_sitinurr]

Thank you for sharing these useful tips. Some points are not shared during my 3 days Power BI course that i took. And i had a hard time understanding the concept. Thank god for your channel i took time to slowly understand and replay back those important topics.

[@dumisaralane]

Brilliant! Thank you!😎

[@meltem4267]

I love them especially the tooltips and navigator. Please share more tips with us☺️

[@GiteshBajaj]

Very Informative video. Thank You...

[@raimanachamps4290]

Thanks for those tips. If I may add, using Tabular Editor as external tool is convenient as well to manage measures (moving around, display in folders, formatting). For background image, I usually have the same on every page so importing is tedious. Embedding the image in a custom theme is more efficient in my case. Lastly, locking objects setting doesn't stay when you save and reopen the pbix (unless it's been changed recently).

[@samuelofosu-wiredu1259]

Thank you. As always very impressive

[@HemanthKumar-lb4xt]

Wow! Expert level tips...

[@YazminAbat]

Thanks, your pieces of advice are the best!! My favorite tip is to use a single button to change for example for a time series graph of Quarter sales to monthly sales. We just need to go to button -> style and write the names for both states of predetermined value and hover over cursor. Not sure about the equivalent in English

[@ssb115sv]

Thank you so much! A lot of useful information!

[@miked6523]

Very helpful! Thanks

[@paulnatta8519]

Great tips! A nice concise video and you present them very well. Thank you!

[@kacingo]

thank you Leila and the team, keep going

[@tobifatona3418]

This is very insightful and helpful. Thank you

[@manavmitu]

You are awesome .... Power BI is amazing and what's more amazing is to get tips from your guys on KZbin that make our life easy ... Thanks a ton

[@catherineboama1260]

Thank you for the tips! I am a beginner and I'm glad I found this video

[@chW9938]

Very informative. Thank you!

[@MohamedEhbal]

Thanks so much. Fantastic as usual.

[@MohammadGhaheri33]

So good Specially Creating Custom Tooltips

[@HRHCaleb]

Awesome tips, Thanks!

[@lizdeng4270]

Awesome Tips can't wait to try in my new reports, Thx!

[@ytubid]

Amazing set of tips👍 Thanks so much for sharing

[@mehdid.1022]

Great Tips! Been using PBI for a while, and I still learnt a lot of new things. Thank you! :)

[@utubeAgape]

Yay - Onto PBI now, thank you! The visuals in PBI definitely can’t be beat and are becoming the ‘go to’ in presentations of data. Love the custom tool tip instruction! Would love to see more videos about using DAX with common use-case scenarios.

[@LeilaGharani]

Do you have some specific cases in mind?

[@izzazross6027]

@@LeilaGharani can you cover simple monthly cumulative cash balance please? In my line of work, I'm in charge of 2 entities and we would normally present at consolidated level to management. Issue is, at consolidated level, my cash balance is correct however when I further slice and dice by entities and monthly profile, the cash balances are inaccurate. Love if you can cover this in your next PBI video.

[@utubeAgape]

@@LeilaGharani - I work with people data so any type of calcs involving demographics also thinking of things like min, mid, max salary range, etc. Thank you!

[@idakwiatkowska2862]

@@LeilaGharani also topics like % of total row (like in pivot), how to makes visuals where you compare actual result to previous year result. Different dax calculations and tricks please

[@alicedwonderland7733]

Tip # 6 just blew my mind!

[@phamhuyson1988]

Impressive with easiest way! Love to see more power bi lesson from u

[@pedrohenriquecarneiro904]

Very good tips! Thanks!

[@yourtuber2000]

I've learned something today!

[@deepakcitm]

Thanks Leila for these amazing tips

[@aelwyne6167]

Thank you so much for these tips I have learned a lot and I will apply it on my reports

[@wayneedmondson1065]

Hi Leila. Great collection of tips!. Knew a few and learned a few. Thanks for sharing :)) Thumbs up!!

[@jonelmills1369]

Great Tips Thanks Leila.

[@alexdieudonne1924]

Thanks so much some really helpful ones here, especially tip 9

[@ahmadullahasey7638]

Valuable like no other! Thank you Leila

[@LeilaGharani]

Glad you think so!

[@magagefernando8756]

Than You So Much M/s Leila Gharani..

[@Stijnhillenius]

Thank you, useful, subscribed

[@oliverblancosame7982]

Greats tips Leila,thanks for your knowledge

[@unnikrishnansanthosh]

superb as usual, thanks for sharing 💗

[@ayandapeter1681]

Hi Leila, all I can say is, your content is always amazing, quality videos and excellent presentation and teaching, you never disappoint. I did your power query and google sheets course on Udemy, that was spectacular, now I'm saving for the next one. Thank you very much😀

[@andrew_hubbard]

Thanks for this. It's been a while since I used Power BI and I'm glad that things have improved. The Navigation buttons are really useful. I once spent a long time creating a popup navigation menu for a 20+ page dashboard I created. It would be much easier to do now! I also thought your tip on organising measures very useful. I alway used to put my meassures into tables, but never used Display folders for them. I don't know if this is a recent addition or I just didn't see it when I was creating PowerBI dashboards, thanks for going over this.

[@kostaskolotouros4345]

Good quality content and presentation. Thank you.

[@AKhan-nu9mw]

Great, Thanx very much.

[@14DFASniper]

Sweet! Thank you so much!!

[@jrobinson8898]

Thanks for the great tips!. I especially love the measures organizing tips!! Awesome!!

[@LeilaGharani]

Glad it was helpful!

[@ReactionSquad158]

Leila Gharani I really appreciate your efforts and the way you teach is marvellous.... I really like your way of teaching methods. Plz increase your classes on power bi

[@andreymantrov2559]

Awesome video with very useful tips! Have been using some of those for some time and they save a lot of time!

[@MagdyTawfikA]

Thank you Leila!

[@ahammadgalib5810]

Awesome. Thanks a lot

[@kammuanalysis]

Thank you so much 🙏

[@RogerStocker]

Great work, I love all of these tips😍

[@melinasibaja]

Great video! Thank you!!

[@LeilaGharani]

Glad you liked it, Melina!

[@KleitomAntonioMachadodeSouza]

Great tips, congratulations.

[@jaguarprovo]

Keep them coming!

[@shirleysmith3409]

Thank you so much Leila! I'm myself an advanced report designer and never heard about Tooltips making reference to other pages, let alone that they have contextual filters. That's sooo cool!! We always learn something new from you 😎😎

[@LeilaGharani]

Glad it was helpful Shirley!