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

Рет қаралды 806,789

Күн бұрын

👉 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

Пікірлер: 455

@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 5 ай бұрын

Can I pass the pl300 Certification using this course?

@leewarps 2 жыл бұрын

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 2 жыл бұрын

There are lots of good free courses on YT.

@lucia26 2 жыл бұрын

Either Leila or Chandoo, love them both!

@LifeofBusinessAnalystLoBA 2 жыл бұрын

There are many , you need to search ..

@riccardoczech6195 2 жыл бұрын

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

@bakthapuri 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

I like that! Thanks for sharing.

@idakwiatkowska2862 2 жыл бұрын

There is an option to give the visuals a frame.

@pantomima5841 2 жыл бұрын

@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 2 жыл бұрын

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

@hansklein3649 2 жыл бұрын

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

@juniorakotshi2132 2 жыл бұрын

Thank you so much :-)

@yassirkhalid5376 2 жыл бұрын

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 2 жыл бұрын

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

@theweeklychart 2 жыл бұрын

All of them. Thanks for sharing.

@Isaactibenkana 2 жыл бұрын

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

@kejmil1992 2 жыл бұрын

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!👍🏾

@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.

@AccessAnalytic 2 жыл бұрын

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

@reynaldomorillo4271 2 жыл бұрын

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

@manojraghavan1490 2 жыл бұрын

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

@vijayarjunwadkar 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

I'll try my best, Vijay 😊

@marianhymiel2211 2 жыл бұрын

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 2 жыл бұрын

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

@osPA78 2 жыл бұрын

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

@chrism9037 2 жыл бұрын

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 2 жыл бұрын

There are lot of resources available online ..

@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.

@dp6736 Жыл бұрын

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

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

@manavmitu 2 жыл бұрын

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

@utubeAgape 2 жыл бұрын

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 2 жыл бұрын

Do you have some specific cases in mind?

@izzazross6027 2 жыл бұрын

@@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 2 жыл бұрын

@@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 2 жыл бұрын

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

@eaaeeeea 2 жыл бұрын

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 :)

@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

@mayaabd1248 2 жыл бұрын

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

@LifeofBusinessAnalystLoBA 2 жыл бұрын

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

@cheryldavis9797 2 жыл бұрын

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!

@raimanachamps4290 2 жыл бұрын

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).

@joaquinmaverick82 2 жыл бұрын

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

@xoundful 2 жыл бұрын

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

@paulnatta8519 2 жыл бұрын

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

@mehdid.1022 2 жыл бұрын

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

@meltem4267 2 жыл бұрын

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

@raquelmalonzo5356 2 жыл бұрын

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

@alinick4137 2 жыл бұрын

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

@sarahalachewe3205 10 ай бұрын

Smart and easy teaching. Thanks for this

@shirleysmith3409 2 жыл бұрын

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 2 жыл бұрын

Glad it was helpful Shirley!

@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.

@sunnypotdar6619 2 жыл бұрын

Great video! Really looking forward for your complete Powerbi course in XePlus. When can we expect the course?

@teoxengineer 2 жыл бұрын

Very excelent tips. Thank you Leila, Also, bookmarks can be used for any type of quick selections and visualizations.

@andreymantrov2559 2 жыл бұрын

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

@xZxeclipsexZx 2 жыл бұрын

The tips 6 is amazing ! Thank you !!

@kunjal96 Жыл бұрын

Wonderful Video leila!!!Thnaks

@mohdzulfarhanbinibrahim3510 2 жыл бұрын

This is super helpful, Lella! Much appreciated! By the way, if there are any ways you can show on how to maintain the hyperlinks of certain cells from the original data source (i.e. Excel files) in the Power BI, appreciate a guide on that. Thanks, love your videos!

@zhin4362 2 жыл бұрын

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

@qizhang8682 2 жыл бұрын

Really really helpful, and I am looking forward to such similar tips videos in the future. Maybe I think it can be a series tutorial.

@wayneedmondson1065 2 жыл бұрын

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

@ytubid 2 жыл бұрын

Amazing set of tips👍 Thanks so much for sharing

@PGOManc7 2 жыл бұрын

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

@jrobinson8898 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

Glad it was helpful!

@andrew_hubbard 2 жыл бұрын

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.

@MoeBig50 Жыл бұрын

One of my favorite Power BI videos

@NearLWatson 2 жыл бұрын

Hi thank you for the tips. I am quite familiar and already using all except tips on the tooltip and the buttons. They were really helpful.

@lizdeng4270 2 жыл бұрын

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

@IndianFootsteps 3 ай бұрын

Your tips were so informative and you make it simple so everyone can understand how to use them. Thank you so much. I'm through your 1st two Power BI Videos and I really like the way you explain how to use it. I can't wait to get to the next one! Thank you so much!

@Heyits_sitinurr 2 жыл бұрын

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.

@tobifatona3418 2 жыл бұрын

This is very insightful and helpful. Thank you

@shivareddy7899 2 жыл бұрын

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

@ruslansuleymanov2606 2 жыл бұрын

Hi Leila…Just came accross your first video about pBI. I expect you do more of simplified DAX tutorials for which I’m sure you’d do the best one. You are the start!

@truonghoanghaminh4839 2 жыл бұрын

Happy lunar new year ❤❤

@LeilaGharani 2 жыл бұрын

Same to you!

@maryhelenmorales6622 Ай бұрын

Wow, your videos are outstanding. Thank you for sharing your vast knowledge of Excel, Power BI, and Power Query. I feel funny learning so much from someone I don't even know. Again, thank you so much. Your videos are powerful and help me greatly with the work I do.

@tllittle 2 жыл бұрын

Nice tips, thanks. I usually create a book mark of the final layout view so I can easily return back to this, if I have ended up clicking around the page and filtered too much etc.

@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😀

@kamelgameel1250 2 жыл бұрын

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

@phamhuyson1988 2 жыл бұрын

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

@pedrohenriquecarneiro904 Жыл бұрын

Very good tips! Thanks!

@arjundev4908 2 жыл бұрын

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

@carneypwr 2 жыл бұрын

Amazing. I love the way you teach.

@chW9938 2 жыл бұрын

Very informative. Thank you!

@imeshseepersad 2 жыл бұрын

Really Helpful! Thank you!

@LawrenceYounis 4 ай бұрын

Even i watch these tips after 2 years, but they still very important for professional output, thanks

@LeilaGharani 4 ай бұрын

Glad they're helpful.

@ssb115sv 2 жыл бұрын

Thank you so much! A lot of useful information!

@samadaspt5635 2 жыл бұрын

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

@RogerStocker 2 жыл бұрын

Great work, I love all of these tips😍

@ManaviVideos 2 жыл бұрын

Thanks for sharing valuable content!!

@deepakcitm 2 жыл бұрын

Thanks Leila for these amazing tips

@gkaliota 2 жыл бұрын

I would like to see some PowerBI with Machine Learning videos. Great work!!

@aelwyne6167 2 жыл бұрын

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

@sallahali 2 жыл бұрын

Hi Leila...I was wondering if you have or can create a video about embedding Power BI into PowerPoint. I love your work and how clearly you present it. You have no idea how many time you've got me out a difficult situation...I'm very grateful to you for that!!

@soueujackson9723 2 жыл бұрын

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

@samuelofosu-wiredu1259 2 жыл бұрын

Thank you. As always very impressive

@alexdieudonne1924 Жыл бұрын

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

@shatakshiagrawal3062 2 жыл бұрын

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

@rohitwaradpande2492 2 жыл бұрын

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

@GiteshBajaj 2 жыл бұрын

Very Informative video. Thank You...

@AKhan-nu9mw Жыл бұрын

Great, Thanx very much.

@tommasogerbino6291 Жыл бұрын

Thanks Leila - Excellent!

@dumisaralane 2 жыл бұрын

Brilliant! Thank you!😎

@miked6523 2 жыл бұрын

Very helpful! Thanks

@MohamedEhbal 2 жыл бұрын

Thanks so much. Fantastic as usual.

@ksitistas Жыл бұрын

Very nice video! One small notice about the wallpaper, unfortunately it doesn't appear on pdf exports, so if you intend to use the export to pdf option, you should probably reconsider the use of a custom wallpaper image or color. But if you don't plan to do so, it looks a lot better!

@elhassanaitelhadj8796 2 жыл бұрын

Good tips, thank you Leila for making efforts in this video and sharing, i didnt expect lock object option

@maniknag6468 2 жыл бұрын

Thank you for sharing Tips on PBI Dashboard , As a Pro user I must say it's very very useful & I'll use folder under measures from now. I was looking for this as I've many measures in dedicated DAX Table but since there are many measures so grouping them will be very useful

@catherineboama1260 Жыл бұрын

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

@HRHCaleb 2 жыл бұрын

Awesome tips, Thanks!

@magagefernando8756 Жыл бұрын

Than You So Much M/s Leila Gharani..

@Stijnhillenius 2 жыл бұрын

Thank you, useful, subscribed

@alicedwonderland7733 Жыл бұрын

Tip # 6 just blew my mind!

@dhavalpatel4442 2 жыл бұрын

Power BI converts data into analysis and you make analysis easy to learn with your some really really useful important things to remember and useful for learning whether beginner like me or advanced one... Keep sharing knowledge. I want to learn in details about Power BI. Please guide me...

@kostaskolotouros4345 2 жыл бұрын

Good quality content and presentation. Thank you.

@mirrrvelll5164 2 жыл бұрын

Cool video! But small correction, by "Locking objects" part, you don't need to select any of them and then click on the option above for locking, it is working without selection anyways. Secondly, I think Bookmark option is worthy mentioning, how you can use it as "filter" as so on. By buttons, Navigator pane is amazing, Page + Bookmark navigator s saving you a loooot of time. Anyways, looking forward to your PBI course and approach on that Tool.