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

Поделиться
HTML-код
  • Опубликовано: 21 ноя 2024

Комментарии • 471

  • @LeilaGharani
    @LeilaGharani  2 года назад +12

    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
      @justingill9822 2 года назад

      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
      @alphamal1987 10 месяцев назад

      Can I pass the pl300 Certification using this course?

  • @leewarps
    @leewarps 2 года назад +152

    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
      @mathijs9365 2 года назад

      There are lots of good free courses on YT.

    • @lucia26
      @lucia26 2 года назад +8

      Either Leila or Chandoo, love them both!

    • @LifeofBusinessAnalystLoBA
      @LifeofBusinessAnalystLoBA 2 года назад +1

      There are many , you need to search ..

    • @riccardoczech6195
      @riccardoczech6195 2 года назад

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

    • @bakthapuri
      @bakthapuri 2 года назад

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

  • @swake1822
    @swake1822 2 года назад +75

    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
      @LeilaGharani  2 года назад +6

      I like that! Thanks for sharing.

    • @idakwiatkowska2862
      @idakwiatkowska2862 2 года назад

      There is an option to give the visuals a frame.

    • @pantomima5841
      @pantomima5841 2 года назад +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.

  • @judyl.7811
    @judyl.7811 Год назад +18

    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:

  • @cryptidcage3615
    @cryptidcage3615 2 года назад +1

    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.

  • @shirleysmith3409
    @shirleysmith3409 2 года назад +13

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

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

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

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

  • @chrism9037
    @chrism9037 2 года назад +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!

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

  • @marce_f
    @marce_f 2 года назад +10

    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.

  • @utubeAgape
    @utubeAgape 2 года назад +14

    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
      @LeilaGharani  2 года назад +1

      Do you have some specific cases in mind?

    • @izzazross6027
      @izzazross6027 2 года назад +1

      @@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
      @utubeAgape 2 года назад +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
      @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

  • @manojraghavan1490
    @manojraghavan1490 2 года назад

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

  • @kejmil1992
    @kejmil1992 2 года назад +3

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

  • @osPA78
    @osPA78 2 года назад

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

  • @dhavalpatel4442
    @dhavalpatel4442 2 года назад +1

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

  • @HeatherMajors
    @HeatherMajors 2 года назад +1

    Thank you Leila, I am trying to learn Power BI for work and your video is very helpful. I even recommended it to my boss :)

  • @bakthapuri
    @bakthapuri 2 года назад

    Hi Leila,
    You are always with me whenever I struck in middle of any project and need help, just I can open your channel and type the problem. I found the solution.
    Very glad for that..
    Most of the members are waiting for your full power BI course. Can you please make it for us..?? Else can we find it on any learning portals??

    • @LeilaGharani
      @LeilaGharani  2 года назад

      Wonderful! Power BI course is in the works. Stay tuned :)

  • @cheryldavis9797
    @cheryldavis9797 2 года назад +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!

  • @isaacmwabila5830
    @isaacmwabila5830 2 года назад +1

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

  • @sunnypotdar6619
    @sunnypotdar6619 2 года назад +2

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

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

  • @sasikanth91
    @sasikanth91 2 года назад +2

    Thanks!

  • @vijayarjunwadkar
    @vijayarjunwadkar 2 года назад +3

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

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

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

  • @shivtechviral7510
    @shivtechviral7510 2 года назад +1

    Please share more of power bi related tips and shortcuts.

  • @sarahalachewe3205
    @sarahalachewe3205 Год назад +1

    Smart and easy teaching. Thanks for this

  • @jonelmills1369
    @jonelmills1369 2 года назад

    Great Tips Thanks Leila.

  • @Isaactibenkana
    @Isaactibenkana 2 года назад

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

  • @joaquinmaverick82
    @joaquinmaverick82 2 года назад

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

  • @PGOManc7
    @PGOManc7 2 года назад

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

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

  • @soueujackson9723
    @soueujackson9723 2 года назад

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

  • @LawrenceYounis
    @LawrenceYounis 9 месяцев назад

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

  • @reynaldomorillo4271
    @reynaldomorillo4271 2 года назад

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

  • @tllittle
    @tllittle 2 года назад +1

    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.

  • @manavmitu
    @manavmitu 2 года назад

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

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

  • @ksitistas
    @ksitistas 2 года назад +3

    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!

  • @LeilaGharani
    @LeilaGharani  2 года назад +112

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

    • @hansklein3649
      @hansklein3649 2 года назад +5

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

    • @juniorakotshi2132
      @juniorakotshi2132 2 года назад

      Thank you so much :-)

    • @yassirkhalid5376
      @yassirkhalid5376 2 года назад +1

      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
      @unnikrishnansanthosh 2 года назад

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

    • @theweeklychart
      @theweeklychart 2 года назад

      All of them. Thanks for sharing.

  • @AccessAnalytic
    @AccessAnalytic 2 года назад +1

    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

  • @mayaabd1248
    @mayaabd1248 2 года назад +3

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

  • @rickb.3666
    @rickb.3666 2 года назад

    I can use a few of these. Thanks! When you ask yourself, should I keep doing this, yes. Do one on Whatif variable with slicer and customer retention 😁.

  • @BestICan
    @BestICan 2 года назад +1

    Outstanding as usual. Question on Tip #5 Background Images. If I design on a 1080 display and someone with a 4k monitor maximizes their PBI window, do background images become degraded/pixelated?

  • @ayandapeter1681
    @ayandapeter1681 Год назад +1

    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😀

  • @ReactionSquad158
    @ReactionSquad158 2 года назад

    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

  • @dp6736
    @dp6736 2 года назад

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

  • @maryhelenmorales6622
    @maryhelenmorales6622 6 месяцев назад

    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.

  • @Xrusader
    @Xrusader 2 года назад +1

    Thank you for reminding me of all of these great features. I've forgotten about many of these over time. My company wants to keep a consistent look and feel on every report. Unfortunately, this causes me to get rusty on the other features of Power BI.

    • @LeilaGharani
      @LeilaGharani  2 года назад

      My pleasure! Rust removal is my speciality 😊

  • @xoundful
    @xoundful 2 года назад

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

  • @ranieladriano
    @ranieladriano 2 года назад

    Hi, i'm from Brazil and i don't speak English 😥
    But i always wacht your videos and always learn somethings new, like the tooltips. Thank you for sharing your knowledge.
    Sorry for errors in the text. 😅

    • @LeilaGharani
      @LeilaGharani  2 года назад

      That's great to hear! Thanks for watching!

  • @isaacmensah8143
    @isaacmensah8143 2 года назад

    I have been waiting for your Power BI training to purchase, almost every week I look it up on Udemy hoping it’s ready…no pressure lol

  • @JackSon-zt5hx
    @JackSon-zt5hx 2 дня назад

    You are really best ever I am learning . I wish you can do full power bi , sql , excel and Python about data analysis detail

  • @YazminAbat
    @YazminAbat 2 года назад

    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

  • @govindtribhuvan6344
    @govindtribhuvan6344 10 месяцев назад

    Hii Leila, i am very greatful for having mentor like you. I learn so much from your videos. Plz share more video on Dax and how to use measure and relationship!
    From india

  • @gkaliota
    @gkaliota 2 года назад

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

  • @raimanachamps4290
    @raimanachamps4290 2 года назад +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).

  • @teoxengineer
    @teoxengineer 2 года назад

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

  • @jrobinson8898
    @jrobinson8898 2 года назад +1

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

  • @rumi2431
    @rumi2431 2 года назад

    The way you teach is awesome , also amazing the step by step learning method , its really helpful vedio Thank You So much for sharing

  • @alinick4137
    @alinick4137 2 года назад

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

  • @craftpassion1812
    @craftpassion1812 2 года назад

    These are extremely useful tips as I am learning Power BI. Thank you, Leila!

  • @MoeBig50
    @MoeBig50 Год назад

    One of my favorite Power BI videos

  • @yashubaby317
    @yashubaby317 2 года назад

    Thank you very much.I watch your videos regularly,they are informative and helpful.I watched many videos for separate tool tip for charts,but ur's is the simple and best.I have one request..please help me with water fall chart in power bi. I tried couple of times but its not working.

  • @IndianFootsteps
    @IndianFootsteps 8 месяцев назад

    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!

  • @meltem4267
    @meltem4267 2 года назад

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

  • @ljrockstar69
    @ljrockstar69 2 года назад

    I love Tableau, but now I'm falling in love with Power BI now.

  • @catherineboama1260
    @catherineboama1260 Год назад

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

  • @zhin13
    @zhin13 2 года назад

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

  • @truonghoanghaminh4839
    @truonghoanghaminh4839 2 года назад +2

    Happy lunar new year ❤❤

  • @tonyperkins6925
    @tonyperkins6925 2 года назад

    Very good, I have just started with Power BI and these are exactly the things I need to know.

  • @wayneedmondson1065
    @wayneedmondson1065 2 года назад

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

  • @xZxeclipsexZx
    @xZxeclipsexZx 2 года назад

    The tips 6 is amazing ! Thank you !!

  • @mehdid.1022
    @mehdid.1022 2 года назад

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

  • @srikanthk1817
    @srikanthk1817 2 года назад

    actually i am searching this type of tips. thank you for giving lot of information. i hope you will give more tips about power bi. i am stuck in if ,or condition in power bi. if it possible please do that topic video.

  • @anilreddykanthala3607
    @anilreddykanthala3607 Год назад

    Amazing Techniques .. All my doubts clarified in one superb videos.
    Thanks for the video 🙏

  • @GonzaloOyarce
    @GonzaloOyarce 2 года назад

    Really useful, i will follow you for more tips!!!!
    The custom tooltip was the best!!!

  • @FredericLEGUEN-Excel
    @FredericLEGUEN-Excel 2 года назад

    Hi Leila. #5 #7 #9 are new for me. Great job 👍

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

  • @eaaeeeea
    @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 :)

  • @alicedwonderland7733
    @alicedwonderland7733 Год назад

    Tip # 6 just blew my mind!

  • @b0rme
    @b0rme 2 года назад

    The page tooltips looks like a game changer. If only my organisation gave us pro licenses to share reports instead of having to create PDF's

  • @vishwanath1810
    @vishwanath1810 2 года назад

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

  • @elhassanaitelhadj8796
    @elhassanaitelhadj8796 2 года назад

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

  • @libbyzhang824
    @libbyzhang824 2 года назад

    Great video! Thank you Leila. Is it possible to have a quick tips video on how to make the dashboard looks great, eye catching, and clear? I found myself spending so much time to do the final cosmetics but still not happy about it.

  • @TAIMIUWU
    @TAIMIUWU 2 года назад

    Brilliant video. Very impressed with your video and the way to teach them through.

  • @tobifatona3418
    @tobifatona3418 2 года назад

    This is very insightful and helpful. Thank you

  • @aelwyne6167
    @aelwyne6167 2 года назад

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

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

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

  • @rohitwaradpande2492
    @rohitwaradpande2492 2 года назад

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

  • @abdulmajidfaraji3659
    @abdulmajidfaraji3659 8 месяцев назад

    Hi, Leila. Thanks for this wonderful tutorial, been following your lessons with great enthusiasm. In 'Organizing Measures', when you hide 'Column 1', the KPI table automatically gets moved to the top. I also tried deleting the column, and the same thing happened, i.e., the KPI table was moved to the top. What's the essence of hiding as opposed to deleting? Is it possible to somehow reuse the blank column later when you hide it? In which scenarios is the reuse possible?

  • @eslamfahmy87
    @eslamfahmy87 6 дней назад

    Thank you, Leila, as usual .. Could you share with us how to bueatyfiy your report, by how to add more colors regarding color wheel of PI, and how to insert shabes and then combine with your cards..etc.

  • @muzahmad2104
    @muzahmad2104 Год назад

    What a gem of a power BI video! Leila you have a natural talent. All the tips are wonderful. Tool tip could be so handy. I’d be interested in seeing a video that shows how to join multiple datasets and builds measures.

  • @ExcelTutorials1
    @ExcelTutorials1 2 года назад

    This is a great video! I need to improve my Power BI skills and this helps a lot!

  • @arunshekar2658
    @arunshekar2658 Год назад

    you never disappoint on the topics u jump into :)

  • @mutumbawycliff784
    @mutumbawycliff784 Год назад

    Thanks Leila, I really appreciate this. Very Very Important tips. You one of my best, how can I join your advanced Power BI trainings?

  • @paulnatta8519
    @paulnatta8519 2 года назад

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