7 Tips & Tricks for Stunning Power BI Reports!

Поделиться
HTML-код
  • Опубликовано: 21 июл 2024
  • Hi everybody! Parker here. Check out this webinar that I recently gave showcasing 7 Power BI tips and tricks that you should add to your Power BI dashboards and reports. These tricks include bookmarks, drillthrough, hierarchies, dynamic measures, forecasting, row-level security (RLS), and subscriptions.
    Professional Power BI Services:
    bielite.com
    To enroll in my introductory or advanced Power BI courses:
    training.bielite.com/
    Connect with me on Twitter!
    / powerbielite
  • НаукаНаука

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

  • @moulik2341
    @moulik2341 4 года назад +98

    Tip-1 : Hiding filter pane 1:50
    Tip-2 : Drillthrough 9:22
    Tip-3 : Hierarchies 14:44
    Tip-4 : Dynamic Metrics 20:27
    Tip-5 : Forecasting 28:38
    Tip-6 : Row level security 36:18
    Tip-7 : Email subscriptions 40:03

    • @BIElite
      @BIElite  4 года назад +2

      Very helpful, Mouli. Thanks!

    • @moulik2341
      @moulik2341 4 года назад +1

      @@BIElite
      Welcome bro 😎

    • @Juggler707
      @Juggler707 3 года назад +4

      you forgot 13:28 - channelling of Trump

  • @manishm8635
    @manishm8635 3 года назад +4

    Good to see all topics covered in single video, Thanks a ton Parker for walking us thru the report with tips & tricks.

    • @BIElite
      @BIElite  3 года назад +1

      No problem, manish!

  • @tejasbrahmbatt5344
    @tejasbrahmbatt5344 4 года назад +3

    Hey Parker,
    Great webinar.
    Can you show how to implement RLS on Power BI report server?

  • @thereal_jasonleong
    @thereal_jasonleong 3 года назад

    Hi, great video! quick question about dynamic metrics, is it possible to add different units to each of the selections?

  • @shrutisinghal8556
    @shrutisinghal8556 4 года назад +1

    I love your video. Thanks for making it available to us :)

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

    Great video, as always.! Thank you! Quick question - when I hide a visual for bookmarks, the filters reset to the original state. Do you know why this may be happening?

  • @r.m1447
    @r.m1447 3 года назад +2

    Many useful features in a single tutorial.Good job

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

    Great video! Thanks for sharing tips! I was looking some of them for long time. Thank you.

  • @saojoaomeriti
    @saojoaomeriti 3 года назад

    Hello!
    Your videos is amazing! Could you create a video teaching us how to create "First Pass Yield" chart on Power BI?

  • @indrewhite
    @indrewhite 4 года назад

    great video! thanks for sharing tips! Is there downloadible workbook available for reference?

  • @sands7779
    @sands7779 4 года назад +2

    well done for clear, concise summary of useful power bi tips thank you

    • @BIElite
      @BIElite  4 года назад

      Thanks for watching!

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

    Hey, is there a way to have a slicer with 2 values as one button which changes the table value and the name dynamic? (Imagine 28:50 only having Profit and Revenue and to only change between those 2 with only 1 button)

  • @mathewinmuscat
    @mathewinmuscat 4 года назад +1

    Great video, as always. Thanks a ton.

  • @Gunterlund583
    @Gunterlund583 4 года назад +1

    I noticed on your visuals you dont see the top band that shows the filter icon or three dots. Is that possible to turn on and off?

  • @HarishS12137
    @HarishS12137 4 года назад

    Most helpful and simple tricks, thank you!!

    • @BIElite
      @BIElite  4 года назад

      Thank you for watching, Harish!

  • @mohammadshaikh1191
    @mohammadshaikh1191 4 года назад +1

    Hi Awesome tips, Thanks for sharing, is it possible to share the pbix file to learn more. Many Thanks

  • @pgayatri559
    @pgayatri559 4 года назад

    Can we apply the same features such has dynamic values of cost, revenue and quantity in the current report showed by you, for Year to Day level

  • @SoulSeeker770
    @SoulSeeker770 4 года назад +1

    Thank you so much for this video.

  • @kamransamad9686
    @kamransamad9686 3 года назад +1

    Very well explained, thanks.

  • @datawhipper
    @datawhipper 3 года назад

    Wonderful and relevant tips.

  • @aravindl3540
    @aravindl3540 3 года назад

    Can you explain how to pull values from different columns in a second table based on the values from a column in the first table..

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

    Great video mate! I learned a lot, thank you!

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

    Loved it! Thanks for sharing!

    • @BIElite
      @BIElite  3 года назад

      No problem!!

  • @shashirajusiddaraju4979
    @shashirajusiddaraju4979 3 года назад

    Very informative, Thank you so much

  • @jasonabbott3874
    @jasonabbott3874 3 года назад +3

    Great video.
    Apologies if it has been asked before - which map visual are you using that sits under the country bar chart? I can't seem to replicate it from the choices available (and none of the ones available are as snappy to use as this appears)

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

      I have the same question!

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

    Very helpful. Great examples.

    • @BIElite
      @BIElite  3 года назад

      Thank Justin!

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

    Hey, at the top of the report there is a visual which allows you to chose the start and end date. Can you tell me what that visual is exactly and a source to learn how to use it?

  • @JonathanCHANAL
    @JonathanCHANAL 4 года назад +2

    Thank you, I already use more or less all these tips and tricks because I followed all your previous videos and this is just perfect! Thank you for all you do for the community ;)

    • @BIElite
      @BIElite  4 года назад +2

      Thanks for watching, Jonathan! I really appreciate comments like this

  • @o0pinkdino0o
    @o0pinkdino0o 4 года назад

    When forecasting (out of box model) with data that goes back years, I put 12 months and 365 Point(s) for 1yr forecast and 1 month and 365 Point(s) for 1mth forecast. Every single date needs a value to perform this or it errors out. So any days with no counts need to be amended with a value of at least 1 (which is easy cos we always use a blank calendar in our models, don't we ?)
    So 365 days forecast = 365 days with at least 1 counted in null fields across 12 months or 1 month (or 3mths for Qtr if you are bothered).

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

    ausgezeichnete Arbeit! Vielen dank!

  • @martijn1975
    @martijn1975 4 года назад +1

    Nice one! I like the SelectedMetric, but I can't seem to find where to change the (number)formatting for the selected metric.

    • @tuandhtl
      @tuandhtl 3 года назад

      Zd

    • @BluesFanUK_
      @BluesFanUK_ 11 месяцев назад

      Did you find out how to do this?

  • @pgayatri559
    @pgayatri559 4 года назад

    And will it change the multiple visuals at the same time in terms of look, let take a situation where I have 4 Bar charts having year to day level hierarchy. How we can achieve the functionality if will drill down to next hierarchy for one chart it supposed to drill down to same hierarchy level for other charts also

  • @galymzhankenesbekov2924
    @galymzhankenesbekov2924 3 года назад

    thanks for the video, can i have your dataset ? thanks

  • @kennethstephani692
    @kennethstephani692 3 года назад +1

    Terrific video, Parker!

    • @BIElite
      @BIElite  3 года назад

      Thank you Kenneth!

  • @shoeb1359
    @shoeb1359 4 года назад +1

    Very Helpful.Could you please share your Pbix file.

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

    Is there anywhere I can get a PDF/Word file of all the menu options in PowerBi? I love the product but there are so many little icons, toggles and suboptions that I'd love a copy of them printed out! (ps. Thanks, great video!)

  • @darkspl
    @darkspl 4 года назад

    U rox!!! Pleased can u share a complete learning part for person that wants to be a business intelligence specialist with Power bi? I started with learning about databases reading database design for mere mortals.

  • @BluesFanUK_
    @BluesFanUK_ 11 месяцев назад

    For the dynamic slicer, how would you format the code so the quantity is in thousands and the revenue is in currency?

  • @matthewmansmoviesinminutes2899
    @matthewmansmoviesinminutes2899 3 года назад

    what visual is that combined bar and geo setup ?

  • @riazuddin7493
    @riazuddin7493 3 года назад

    Can you please let me know the DAX for counting total staff number at on particular point in time. I have employee data in which date of joining is since 1974 to 2021 is there any way if I select 2019 then the total staff headcount show total staff who were present in 2019 whether or not they joined in 2019 in other words a cumulative total of staff whose date of joining is 2019 and backwards?

  • @SuperAzizx
    @SuperAzizx 4 года назад +1

    good presentation clear info i like your videos !!

    • @BIElite
      @BIElite  4 года назад

      Thank you very much!

  • @zacs7971
    @zacs7971 4 года назад

    Great Video. Would you be so kind to share where one might find the pbix file or dataset used to build this?

  • @muskinggazelle3375
    @muskinggazelle3375 3 года назад

    Hi.. Great Visuals.. Can I get a copy of this PBIX file..

  • @sadyaz64
    @sadyaz64 4 года назад +1

    Thank you

    • @BIElite
      @BIElite  4 года назад +1

      Thanks for watching!

  • @satellitepop
    @satellitepop 4 года назад +1

    I would like to know, how you do this map and bars. Do you have any video or tutorial ?

    • @BIElite
      @BIElite  4 года назад +2

      Hi Wellington, I don’t have a tutorial on this, but it’s a simple bar chart overplayed over a map. Not much more than that! It works here because the data kind of leaves a nice area for an extra chart.

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

      maybe a little late but 1st watch this on how to get shape maps ruclips.net/video/YV6y1pX0-hg/видео.html and then look up how you can conditionally format your bar charts chandoo.org/wp/conditionally-format-visuals-in-power-bi/ . Finally you only have to arrange the two visualizations, good luck!

  • @hectoralvarorojas1918
    @hectoralvarorojas1918 4 года назад

    Hi Parker:
    Great tips have you resume here!
    Thanks for sharing this great material!

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

    Thanks!

  • @marlonholland955
    @marlonholland955 3 года назад

    Moving to Power BI from Tableau. Power BI makes so much more sense tbh

  • @semperdiscendum7439
    @semperdiscendum7439 4 года назад

    Awesome!!👍👍

    • @BIElite
      @BIElite  4 года назад

      Thanks Shashikant!

  • @Spartan1Four1
    @Spartan1Four1 3 года назад

    This webinar is awesome! How does become a certified PowerBI professional

    • @BIElite
      @BIElite  3 года назад

      Thanks! To become certified in Power BI, you must take the DA-100 exam. We have a DA-100 Prep Course that covers every topic tested on the exam: training.bielite.com/courses/da-100-exam-prep-power-bi-certification/

  • @kautsarmuhammad6519
    @kautsarmuhammad6519 3 года назад

    How to compile power BI dashboard without publish?

  • @nirjadeshmukh3963
    @nirjadeshmukh3963 3 года назад

    Hi Parker. I'm looking for online tutorials. Please let me know how to get in touch with you, in case you are available to give online tutorial. Thank you.

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

    Thank you -0 very helpful

  • @andrewalfred3473
    @andrewalfred3473 4 года назад +1

    Nice

    • @BIElite
      @BIElite  4 года назад

      Thanks Andrew!

  • @o0pinkdino0o
    @o0pinkdino0o 4 года назад

    You ever need a kidney, I have one spare for you.

  • @tiwarianiljagarnath2243
    @tiwarianiljagarnath2243 4 года назад

    xxx

  • @papachoudhary5482
    @papachoudhary5482 4 года назад

    Thanks!

    • @BIElite
      @BIElite  4 года назад +1

      And thank you for watching!