Help your Power BI report users with an Information Panel

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2024

ความคิดเห็น • 192

  • @RQQ02
    @RQQ02 ปีที่แล้ว +24

    To remove the transparent borders and make the info panel overlay fill the entire screen in Power BI, follow these steps:
    1. Select the "Info Panel Overlay" image that you have inserted from the "Selection" Panel.
    2. Open the "Format" panel and select "General" -> "Properties" -> "Padding".
    3. Change the value of "Padding" from the default 5px to 0px.
    The issue is within Power BI, not PowerPoint, Photoshop, whatever you used etc.

    • @sdalarco07
      @sdalarco07 ปีที่แล้ว +2

      Thanks for sharing this tips! It was perfect! 🥰

  • @tomkochka2058
    @tomkochka2058 11 หลายเดือนก่อน +1

    As a relative newbie (only been working with PBI for about a month now) I find your videos super informative. Thank you!

  • @saral.martin6816
    @saral.martin6816 ปีที่แล้ว +1

    This was just what I needed today. I ended up doing the info shapes in Power BI. In my world, no report is ever done, so that made it more easily manageable for the future. Callouts are harder to control in Power BI, but it can be done.

  • @Adi_7004
    @Adi_7004 3 ปีที่แล้ว +17

    Seriously, this is B A N A N A S!! Creativity has no limit. Thanks a ton Adam!

  • @ashleylambe9871
    @ashleylambe9871 3 ปีที่แล้ว +5

    I just created this last night! I was too excited after watching your previous video around this, so thought I'd take a stab at it. I actually referenced your video from 2019 on creating a slicer panel, and created the transparent overlay + text boxes/images with shadows to get a similar effect. It is such a simple concept, but extremely valuable for the end user. Thank you Adam!! That's BANANAS!!!

    • @stuartmccloud307
      @stuartmccloud307 3 ปีที่แล้ว +1

      Ha, exactly what I did :) I like this version better though, the transparency looks so cool.

    • @mustafabiviji00711
      @mustafabiviji00711 3 ปีที่แล้ว +1

      Agree even i did it in Power BI using shapes, text boxes. But this probably is an interesting alternative as you can add different callout shapes and the entire thing is easier to manage as one image. Drawback is probably if user clicks anywhere this would the entire panel would vanish

    • @mustafabiviji00711
      @mustafabiviji00711 3 ปีที่แล้ว

      @@ashleylambe9871 you probably cannot have text boxes with arrows (conversation boxes). Also if the user clicks on text box it might not close as the shape act as a button.
      Personally I would just add and use a X button to close the info panel.

  • @gurpreetmann241
    @gurpreetmann241 3 ปีที่แล้ว +1

    Just applied this to a report... Its amazing! A great way to encourage users and build confidence without documentation!

  • @NathanBlevins
    @NathanBlevins 2 ปีที่แล้ว +5

    This is a super helpful tutorial. I come back to it often. :) One tip: Adam suggests that, if you don't like the borders, you need to get some image editing software. One easy way to work around this is to just to resize your powerpoint slides. Design ==> Slide Size. By trimming up to the size of the slides, you can scale this to a near perfect fit.

    • @joeharkness6846
      @joeharkness6846 ปีที่แล้ว +2

      I discovered that you can also change the padding on the image in PowerBI to zero for all sides -- it is 5 by default.

  • @andyparkerson
    @andyparkerson 3 ปีที่แล้ว +42

    I knew that PowerPoint was a vital part of the PowerApps family!

    • @GuyInACube
      @GuyInACube  3 ปีที่แล้ว +1

      HAHAHA indeed 👊

    • @FlorianKx
      @FlorianKx 3 ปีที่แล้ว

      PowerPoint definetly deserves the Power in its name 😂

  • @ronald1899
    @ronald1899 3 ปีที่แล้ว +2

    Tu canal es lo mejor que e visto en todo youtube, sigue haciéndolo bien, muchas gracias por todo. Saludos desde Chile.

  • @jidi10
    @jidi10 3 ปีที่แล้ว +8

    Great tip, saves time in creating a separate guidance document. I set the PPT to have transparent background, then just set the background of the image in PBI to the color I want and 80% transparent. Solves the stroke issue, as well as allows me to change the color of needed without having to create another PNG.

  • @zitta109
    @zitta109 9 หลายเดือนก่อน

    Awesome tutorial! Thanks a lot!
    FYI: The edges are there because the image has added 5px padding in PowerBi and not in PPT. You can remove that int the Format Image > General > Properties > Padding.

  • @taylorkoep8168
    @taylorkoep8168 3 ปีที่แล้ว +3

    This is super helpful and I think will add a lot of value to end-user without having to explain and train people on what things mean. Thanks for the tutorial!

  • @sue_bayes
    @sue_bayes 3 ปีที่แล้ว +1

    love it :), do this all the time but hadn't thought of taking a screenshot of the canvas to use as a guide and then delete it ... duh me, how many clicks have you saved me

    • @antonycatella5901
      @antonycatella5901 3 ปีที่แล้ว

      This is such a great idea. Takes a bit more time though with reports that are multiple pages (20+)

  • @molloarden8938
    @molloarden8938 ปีที่แล้ว

    At 4:31 right click to save won't work after control A to select all objects

  • @sbrophy100
    @sbrophy100 3 ปีที่แล้ว +5

    This is fantastically genius and yet so simple, love it!

  • @saikirankusumanchi4522
    @saikirankusumanchi4522 3 ปีที่แล้ว

    have been doing this just using pbi desktop, we have the message box(shape) and a overlay rectangle (Transparency can be controlled in pbi). But your way is also good

  • @maxglasby2226
    @maxglasby2226 3 ปีที่แล้ว +1

    Hi. This works really well and is very useful, however, I am using it on PBI screens where the data changes, depending on what graph column is selected. When I place in the overlay, the graph data, at the time of placing the overlay, defaults and changes the data result. I have followed the instructions to the letter but cant get past this problem. Cheers. Max.

  • @chriswall4795
    @chriswall4795 3 ปีที่แล้ว +1

    Thanks, Adam. Glad we all asked!

    • @GuyInACube
      @GuyInACube  3 ปีที่แล้ว +1

      Happy to provide. It's a great technique.

  • @AmplifiedYeesh
    @AmplifiedYeesh 3 ปีที่แล้ว +16

    The "edge" in Powerpoint, is just because your shape has a stroke :) All you need to do is remove the stroke of the shape and you won't have an edge

    • @gabrieldiniz2504
      @gabrieldiniz2504 3 ปีที่แล้ว +2

      hello sir, how do i do this ?

    • @CJ-jc8tn
      @CJ-jc8tn 3 ปีที่แล้ว

      Thanks for the tip. Could you please explain how to do this in PowerPoint as I couldn't find anything on Google about removing the 'stroke of the shape'. Thank you

    • @robsaperstein1681
      @robsaperstein1681 3 ปีที่แล้ว +3

      A workaround I've used is to create the semi-transparent shape in Power BI and only bring in the text bubbles from PowerPoint

  • @gisgis5985
    @gisgis5985 2 ปีที่แล้ว

    This is great. Thank you. But after publishing to the service, it takes some time to load info panel. any tips?

  • @MariaOliveira-fz5ux
    @MariaOliveira-fz5ux 2 ปีที่แล้ว +1

    Hey Adam, I've been trying forever to create the panel without the edges/frame when inserting the image to Power BI. Any tips on how to achieve this in Photoshop?

  • @Irishtone
    @Irishtone 3 ปีที่แล้ว

    I don't have anything constructive add here, but I just had to say... I'm bloody loving your works lads!

  • @jorge72garcia
    @jorge72garcia 7 หลายเดือนก่อน

    This is awesome! Any suggestions on how to use this feature for reports that scroll?

  • @peterg4130
    @peterg4130 3 ปีที่แล้ว +1

    Kind of unrelated, but HOW do you get the line chart to display the years and months in order, and grouped that way??

  • @Tuhcrw
    @Tuhcrw 3 ปีที่แล้ว

    I've just used this process at work and it is very good. Thanks for the suggestion and for taking us through it.

  • @rosswaterston
    @rosswaterston 3 ปีที่แล้ว +1

    Great idea, simple to implement and anything that helps your consumers understand the content is worth its weight in gold!

  • @jamesdabbene1911
    @jamesdabbene1911 10 หลายเดือนก่อน

    Love this idea, cheers for creating the video, to date had been creating power point presentation separately to support dashboards created, can't wait to get stuck in

  • @juansepowerplatform
    @juansepowerplatform 3 ปีที่แล้ว

    Amazing, This idea to use Powerpoint to create the canvas layout is just great. Thanks

  • @mustafabiviji00711
    @mustafabiviji00711 3 ปีที่แล้ว +4

    Adam, thanks for sharing this. I believe this could be done in Power BI itself, just that you lose the flexibility of callout buttons, etc.
    One question/suggestion: Would it be better to have a cancel (X) button on the right hand side top corner of the overlay to close the info panel overlay. Just clicking anywhere (or specially on text boxes) might confuse the user (as users tend to click on such text boxes while discussing!)

  • @AmritaOSullivan
    @AmritaOSullivan 3 ปีที่แล้ว

    This is frikkin brilliant! Thank you. So simple and will transform any report!

  • @phanatik101
    @phanatik101 ปีที่แล้ว

    This is awesone. Thank you
    One remark, after publishing and transform into app, you don't need the CTRL to open it. A simple click will do.

    • @GuyInACube
      @GuyInACube  ปีที่แล้ว +1

      yup. the CTRL is only needed in Power BI Desktop. Well Specifically when authoring.

  • @robinneven1237
    @robinneven1237 3 ปีที่แล้ว +1

    Great video! But can't you do the same from within Power BI? You can also add shapes etc. in there right?

    • @meetdenis82
      @meetdenis82 3 ปีที่แล้ว

      Yes you can. But it would mean those many individual objects to hide/unhide in the selection panel. Having an image is a more efficient way

    • @robinneven1237
      @robinneven1237 3 ปีที่แล้ว +1

      @@meetdenis82 True, but what if you group the see-through picture and text boxes? Haven't tried it myself though...

  • @mchamarelli007
    @mchamarelli007 3 ปีที่แล้ว +1

    Super easy to do and very powerful. Loved it

    • @GuyInACube
      @GuyInACube  3 ปีที่แล้ว

      Glad you liked it!! 👊

  • @stasynech
    @stasynech 2 ปีที่แล้ว +1

    Adam, thanks for sharing! As always very interesting and clear!

    • @GuyInACube
      @GuyInACube  2 ปีที่แล้ว

      Appreciate that! Thank you so much 👊

  • @grubybb
    @grubybb 3 ปีที่แล้ว +2

    This is what I need! Thank you so much!

  • @hey_keith
    @hey_keith 3 ปีที่แล้ว

    Been waiting for something like this for years! Thank you Adam!

  • @KoundinyaPulipaka
    @KoundinyaPulipaka 3 ปีที่แล้ว

    That’s a great presentation of info from now I’ll be using this way. Thankyou so much

  • @kimglick2494
    @kimglick2494 3 ปีที่แล้ว

    Amazing 👏. I add a quick start guide tab with info but this is even better

  • @andreymantrov2559
    @andreymantrov2559 ปีที่แล้ว

    Thanks, this helped a lot! I have found that if your page in power bi is not standard size, you can just change the power point slide to the same dimensions as your power bi page! Just in case someone finds it useful

  • @yanzeng8038
    @yanzeng8038 3 ปีที่แล้ว

    It is so great! but our team thinks it is hard to implement into a standard process and source control since it involved the PowerPoint part. every time something changed, we need to redo the image. How can we make a stunning report but also making sure that all are part of the code and can be source control?

  • @aleksandermolin1053
    @aleksandermolin1053 3 ปีที่แล้ว

    Thank you so much for sharing Adam! Really enjoy all your content.

  • @Kralandaddict
    @Kralandaddict 3 ปีที่แล้ว

    I really like it! Thanks for this great tip! Why did you use a blank button to open the info panel bookmark? Could you not have put an action on your interrogation mark image directly?

    • @antonycatella5901
      @antonycatella5901 3 ปีที่แล้ว

      You could add an action to a Help button as well. It might have been done this way to modify the background colour of the blank button when clicking / hovering.

  • @southpaww
    @southpaww 8 หลายเดือนก่อน

    Is it possible to perform the show/hide using a slicer, instead of a button? I've got a survey that is conducted in fall and spring, but the questions vary slightly between seasons and so i have two report tabs. I want to make the report page white (covered in a white shape) when spring is filtered. and I want spring to be hidden when fall is filtered, etc.

  • @granthunking1699
    @granthunking1699 2 ปีที่แล้ว

    Super cool, Adam! Thanks for sharing!

  • @koboldVH
    @koboldVH 3 ปีที่แล้ว

    Great and simple solution for a report manual! Thnx guys!!

  • @zelik33
    @zelik33 3 ปีที่แล้ว

    Great inspiration - thank you. I’m using PowerPoint also to create some background but this is definitely a next level with this info panel. Thanks once again.

  • @AmitRoy-om3tp
    @AmitRoy-om3tp 3 ปีที่แล้ว

    This is really awesome, Adam! Thanks a lot for sharing this.

  • @uhelalify
    @uhelalify 2 ปีที่แล้ว

    Smart idea. Thanks for sharing. Expecting more from you guys.

  • @williamleveson-gower5088
    @williamleveson-gower5088 2 ปีที่แล้ว

    Awesome !, my users are happier !. I used Power Point, finished with Photoshop to match PBI page size.

  • @thomasivarsson2468
    @thomasivarsson2468 3 ปีที่แล้ว +1

    Great Video Adam!

  • @Solivagus10
    @Solivagus10 3 ปีที่แล้ว

    Simple, elegant solution! Love it!

  • @artemburov9456
    @artemburov9456 3 ปีที่แล้ว +1

    Super cool!! Simple and efficient!

  • @R3dnut84
    @R3dnut84 2 ปีที่แล้ว

    is there a version of this dashboard that's available for download? ive noticed the one you and patrick often use in your videos is the same. I'd love to get a copy so i can see how it's displayed in excel. specifically, i'm having some issues with my data and slicers and i think my main issue is the data model im using in excel. thanks.

  • @manelmehenni7318
    @manelmehenni7318 2 ปีที่แล้ว

    Amazing tip! Thanks for all your great videos

  • @JayBellchambers
    @JayBellchambers 3 ปีที่แล้ว +1

    I love this! Thanks so much for sharing.

    • @GuyInACube
      @GuyInACube  3 ปีที่แล้ว

      Most welcome! 👊

  • @wynhopkins4023
    @wynhopkins4023 3 ปีที่แล้ว

    Great tip on the transparency

  • @andreapremoli4650
    @andreapremoli4650 3 ปีที่แล้ว

    Awesome! I love your smart way of solving problems!
    Also I wonder whether you guys have any idea on how to make a percentage difference of one filtered value vs another (e.g. I select "Texas" in a slicer, "Alabama" in another, and I can show in a card the % difference between the revenues in Texas and the revenues in Alabama). Any suggestion on how to work with this "dynamic filters"?

  • @cheetah9839
    @cheetah9839 3 ปีที่แล้ว

    Excellent. Thank you for the video. Love it

  • @sinansayim7221
    @sinansayim7221 3 ปีที่แล้ว

    Hello Adam.. Awesome Video.. I'm going to use this for my report..regards from Germany

  • @dansmela9701
    @dansmela9701 3 ปีที่แล้ว

    Adam where can I download that black sidebar (left if your screen) image that you attach the buttons to?

    • @antonycatella5901
      @antonycatella5901 3 ปีที่แล้ว

      You could create it in PowerPoint and save the PPT slide as a PNG file and then use it as a background on your report page. You could also add a rectangle shape to your report page and add the PBI icon as well. The benefit of the PNG file is that it is 1 background image and not multiple visuals e.g. shape + icon

  • @danielmm3225
    @danielmm3225 8 หลายเดือนก่อน

    You can make a pixel perfect shoot of the report by exporting to pdf from power bi desktop, convert to image and adjust size to 1920 1080 in paint3D

  • @MonaMayfair1981
    @MonaMayfair1981 ปีที่แล้ว

    Really helpful thank you Adam

  • @saidfawzy
    @saidfawzy ปีที่แล้ว

    GREAT GREAT GREAT ... You are really as usual in all your videos ... DO MAGIC

  • @carolinecarlish9826
    @carolinecarlish9826 3 ปีที่แล้ว

    I can't get my PPT image to expand to cover the full report page size in Power BI - any idea why?

  • @AleKira001
    @AleKira001 3 ปีที่แล้ว

    Thank you Adam! This is so cool

  • @mandarvv
    @mandarvv 3 ปีที่แล้ว

    How about using SVG image type?

  • @McKaySavage
    @McKaySavage 3 ปีที่แล้ว

    Really nice trick. Great user experience! Will definitely use this.

  • @mtrader6194
    @mtrader6194 2 ปีที่แล้ว

    How you have got this Black Strip With filter and Question Symbol on it @guy in a Cube

  • @kristla100
    @kristla100 3 ปีที่แล้ว

    This is brilliant! Thank you for sharing! 👏🏻👏🏻

  • @MariuszRepczynski
    @MariuszRepczynski 3 ปีที่แล้ว

    Thanks Adam, loving it!

  • @outdoorsyaaron
    @outdoorsyaaron 3 ปีที่แล้ว +1

    Nifty! Thanks for sharing!

  • @nathanphillips3628
    @nathanphillips3628 3 ปีที่แล้ว +1

    Top shelf. Thanks for this.

  • @Magurumadeps
    @Magurumadeps 3 ปีที่แล้ว

    Thank You so much 4 an inspiration!! 👏👏👏

  • @casingena1985
    @casingena1985 3 ปีที่แล้ว +1

    A great tip and I love the concept of using other applications like PowerPoint and Snagit, this has further potential :)

  • @sahilsinghal9472
    @sahilsinghal9472 3 ปีที่แล้ว

    Brilliant stuff. Thank you 👏🏼👏🏼👏🏼

  • @vittoriogiatti
    @vittoriogiatti 3 ปีที่แล้ว +1

    Please, can someone explain me how to set dark theme in pbi desktop? Thanks!

  • @ashwinidas7142
    @ashwinidas7142 3 ปีที่แล้ว

    Hi,
    I have data coming from multiple SharePoint list into Power BI and I get out of memory error.
    How do I fix it?

  • @DataMama4
    @DataMama4 2 ปีที่แล้ว

    This is so amazing! You are so creative and have taught me so many cool tricks to wow my coworkers! :)

  • @LifeNFood
    @LifeNFood ปีที่แล้ว

    what to do if the report horizontally long

  • @nourlchann
    @nourlchann ปีที่แล้ว

    Great trick, great video, just GREAT.

  • @stephanieseverich9538
    @stephanieseverich9538 3 ปีที่แล้ว

    On a completely unrelated note - where did you get your shirt?

  • @jacoblee1954
    @jacoblee1954 3 ปีที่แล้ว

    You guys are good! Thank you so much for sharing your knowledge with us :)

  • @ktmthrs
    @ktmthrs ปีที่แล้ว

    This is so helpful!!

  • @mattgranado8353
    @mattgranado8353 2 ปีที่แล้ว

    Incase someone hasn't already given this tip. To fill the PNG picture so you don't have those edges showing. All you need to do is select the Format style and select "Fill"

  • @Gseyjcjdsthbcsdujcc
    @Gseyjcjdsthbcsdujcc 2 ปีที่แล้ว

    This is incredible thanks!!

  • @realitychecktime101
    @realitychecktime101 3 ปีที่แล้ว

    Curious, instead of creating a static image for this in powerpoint, why wouldn't you just add a transparent box and the tooltip boxes/bubbles within Power BI itself with layering?

    • @antonycatella5901
      @antonycatella5901 3 ปีที่แล้ว

      As Adam mentioned in an earlier reply to another comment to this video, it is all about reducing the number of visuals on a page to optimise the performance of the report page: 1 visual vs 5

  • @AbhishekJain-jl3oj
    @AbhishekJain-jl3oj 3 ปีที่แล้ว

    Can we add animated visualization in Power BI?

  • @orkhannazarov2781
    @orkhannazarov2781 3 ปีที่แล้ว

    Thanks for sharing the awesome videos.

  • @joelngige5776
    @joelngige5776 2 ปีที่แล้ว

    This is freaking amazing tip!!! Awesome

  • @mwaltercpa
    @mwaltercpa 3 ปีที่แล้ว +1

    Love it, thank you!

  • @birhanaydn6508
    @birhanaydn6508 3 ปีที่แล้ว

    Adam, it is amazing thank you

  • @shepherdmakanza5953
    @shepherdmakanza5953 2 ปีที่แล้ว +1

    cool trick. I used to do a video and upload it to Ms Stream then put a link on the app. But this is really cool and easy.

    • @GuyInACube
      @GuyInACube  2 ปีที่แล้ว

      Definitely different ways to accomplish things. I tend to defer to keeping them within the experience if possible though.

  • @Oprimaita
    @Oprimaita 3 ปีที่แล้ว

    Thanks a lot. I m going to create my panel now 😀

  • @xavirm72
    @xavirm72 2 ปีที่แล้ว

    And what happens when customer has a different display resolution?

  • @adityap8210
    @adityap8210 3 ปีที่แล้ว

    This is awesome. Very helpful to show info to team, who don't want to read the intro page. Great video.

  • @josefedericopresno6668
    @josefedericopresno6668 3 ปีที่แล้ว

    Great video. Thanks!

  • @zelik33
    @zelik33 3 ปีที่แล้ว

    1:18 do I see well the PlayStation symbols? :D you want to tell us something ? :) :)

  • @udusegbe
    @udusegbe 3 ปีที่แล้ว +1

    Awesome, it is! 🤓

    • @GuyInACube
      @GuyInACube  3 ปีที่แล้ว

      hahaha Yes! 👊

  • @adelina3589
    @adelina3589 7 หลายเดือนก่อน

    very helpful! thank you

  • @eminemremains
    @eminemremains 3 ปีที่แล้ว

    Its Amazzing!!! Thanks a ton for sharing :)