Taking Buttons in Power BI Desktop to the Next Level

Sdílet
Vložit
  • čas přidán 31. 07. 2024
  • Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your Power BI Reports shine.
    Connect with Amanda on Twitter: / missamandan
    ********
    LET'S CONNECT!
    ********
    -- / guyinacube
    -- / awsaxton
    -- / patrickdba
    -- / guyinacube
    -- / guyinacube
    -- guyinacube.com
    **Gear**
    Check out my Tools page - guyinacube.com/tools/
    #PowerBI #PowerBIDesktop #GuyInACube
  • Věda a technologie

Komentáře • 343

  • @ThisIsFrederic
    @ThisIsFrederic Před 5 lety +90

    I loved this "100-page" moment so much, thanks for this good laugh!

    • @user-bh2lg4xw5n
      @user-bh2lg4xw5n Před 4 lety +1

      6:06 ))

    • @nmbambo
      @nmbambo Před 3 lety

      For me I think it might be viable only if the pages are group able into logical categories. That way, you can create the button and then add an action to it that opens a panel with subgroup items of various "pages" or "visual pagings" of your choosing. Choosing the item on the panel automatically collapses the panel and shows the page chosen. JustSayin'.

  • @sqldevdba9719
    @sqldevdba9719 Před 5 lety +1

    Thanks so much for this video! We watch Amanda's videos every month and always wonder how the buttons look so awesome. The blank buttons on top of card just blew my mind! Thank you!

  • @anirudhacs8814
    @anirudhacs8814 Před 4 lety

    This channel is awesome! I've watched about 20 of your videos and I love the passion with which you talk. It is not a regular boring tutorial video that is hard to follow. When I'm watching your videos, I'm focussed 100%. Thank you so much! It's helping me a lot in my work

  • @sanchit-sood
    @sanchit-sood Před 5 lety

    Good to see you Amanda... Last time I saw you, was in the Introduction video to Power BI.
    I follow your Power BI updates video. The way you present is amazing , really easy to understand . Thanks Adam for bringing her. :) Keep up the good work Guy's. Lot of us here follow you.

  • @Sanj803
    @Sanj803 Před 5 lety

    Good to see Amanda here with Adam, religiously listening to updates every month and eagerly waiting every month. You are doing great job.
    Please give user some control over data label positioning.

  • @diogopinto6039
    @diogopinto6039 Před 5 lety +5

    Very useful and beautiful design! As for the question, sometimes when I need more realstate I like to create slicers that actually select what measure is being shown in the analysis.

  • @terrapinryepaleale
    @terrapinryepaleale Před 4 lety

    Another AWESOME video tutorial! Glad I'm watching these before we get too deep into our initial Power BI rollout so we can incorporate all the (reasonable) functionality now.

  • @itpatel7268
    @itpatel7268 Před 5 lety

    Excellent video, thanks a bunch to both of you for sharing these OOTB skills.

  • @shivendrakumaryadav5811

    Thank you so much for sharing this. It helped. Additionally, I have used "Sync Slicers" to carry forward the filtration.

  • @maxartman8277
    @maxartman8277 Před 4 lety

    Great video. I'm just starting PowerBI and it is exciting to see all of the things it can do.

  • @EricaDyson
    @EricaDyson Před 5 lety

    Excellent. Thanks so much. Keep them coming! We need your insights and know-how!

  • @leyshonrr
    @leyshonrr Před 5 lety +1

    Fab video, good to have an explanation for the data, display and current page checkbox options. I'd love to be able to group my selection pane items together in the same fashion as bookmarks, then be able to show or hide whole groups of objects, such as my collapsible slicer selection panes. Really like the blank button overlay on cards too.

  • @paulrodriguezrevilla329

    Amanda ... very useful ... i go almost 2 weeks viewing all the material ... thank you for posting ...

  • @mohanrajs871
    @mohanrajs871 Před 4 lety

    Thank you for the video. Really useful with the page navigation as I am embedding the report in the application where vertical scroll makes no visibility to the tab pages below.

  • @daveflood5176
    @daveflood5176 Před 4 lety +1

    Thanks so much! Such a great channel...every video I watch, I learn something valuable!!!

    • @GuyInACube
      @GuyInACube  Před 4 lety

      Great to hear! Thanks for watching Dave 👊

  • @MattyHD403
    @MattyHD403 Před 4 lety +7

    I love how passionate you all are about this. It makes me happy :)

    • @GuyInACube
      @GuyInACube  Před 4 lety +1

      Thanks for the kind words and thanks for watching! 👊

    • @janibashashaik9412
      @janibashashaik9412 Před 3 lety

      @@GuyInACube Hello, it's greate video.can i get that pbix file to see and get more exposure on this plzzzzzzzzz...its really helpful...khwajaameen0786@gmail.com...

  • @Jolaracu
    @Jolaracu Před 3 lety

    I am doing exactly the same as Amanda did with page navigation using buttons, moreover, my client asked me to create an interactive menu that changes from one visual to the other (same product but different measures) so, I am about to get into that visual layering using the selection panel. I had that idea and after this video, I am sure I was pointing in the right direction. Thank you very much Guys.

  • @CCHSmathematics
    @CCHSmathematics Před 5 lety +1

    I use buttons often but have not layered a button on a card. I love the idea and already know of a few ways this will help save real estate.

  • @mwaltercpa
    @mwaltercpa Před 4 lety +2

    Loved seeing this on the Covid dashboard on the live call this morning. This was helpful :)

    • @GuyInACube
      @GuyInACube  Před 4 lety

      awesome! Yeah you can do some crazy stuff with buttons and bookmarks.

  • @michellejamison6263
    @michellejamison6263 Před 3 lety

    That navigation is awesome! This video has great info and tips. Thx.

  • @nsgoldchannel
    @nsgoldchannel Před 3 lety +2

    This is really REALLY helpful and will change my approach. I'd gone down this route but had reservations as I didn't appreciate the significance of turning off Data, Display etc and couldn't figure out why clicking my buttons erased prior filter choices. Switching off Data in my bookmarks was the eureka moment you gave me to fix this. Thanks so much!!

    • @GuyInACube
      @GuyInACube  Před 3 lety

      YES! 👊 These can be very powerful. Glad it helped you on your journey.

  • @israelgonzalez677
    @israelgonzalez677 Před 3 lety

    Awesome! I am just beginning with Power BI and your videos are quite useful :)

  • @rickystudds
    @rickystudds Před 5 lety

    Sending some love to Amanda! I recognized your voice right away from the Power Bi Update Blog !

  • @varshaks7401
    @varshaks7401 Před 3 lety

    I have done so many cool stuff in my reports after subscribing to your channel. Thanx much

  • @tommartens3953
    @tommartens3953 Před 5 lety +2

    Once again an awesome video, and of course a great guest. Since the April release, I use the title property as it is possible to create dynamic titles - thanks for this feature. Maybe you might consider creating a "toggle" effect, meaning hitting the button the 2nd time goes back to the previous state.

  • @eszterballa-petrasitz8864

    Option to group bookmarks is great, clears things up. What I think could be improved to have this same hierarchy automatically under actions-->bookmark dropdown selection, where you have to assign the action to the button. Otherwise it can be quite chaotic there after a while

  • @pgcsec
    @pgcsec Před 4 lety +1

    Great to see this in action - and now means I can add it to my work - thank you

  • @kapilkumarasamy5059
    @kapilkumarasamy5059 Před 5 lety

    thank you so much... was looking for something that you explained at 4:55 . It helped a lot..

  • @TheVamos777
    @TheVamos777 Před 5 lety

    Like the invisible button trick. Also the selection rename is great, wish it was around when I build a 19 page report with load of visuals

  • @quinitawhitfield9541
    @quinitawhitfield9541 Před 2 lety

    I love that the action of page navigation as an action on a button has replaced the need for a bookmark for each page.

  • @jesuslondonoorozco7447
    @jesuslondonoorozco7447 Před 5 lety +1

    Very useful guys. Your videos have helped me a lot. Keep doing it like that. Thank you :)

    • @GuyInACube
      @GuyInACube  Před 5 lety +1

      Love it! Thanks for watching. 👊

  • @rjcassiafn
    @rjcassiafn Před 4 lety +3

    You're making me actually like Power BI. The UX Team designed a tabs view and I was a bit lost on how to implement it using Power BI but you shed some light on the matter. Thanks.

    • @GuyInACube
      @GuyInACube  Před 4 lety +1

      Love it! I'm gonna get Chris Hamill on one of our live streams to talk more about report design.

  • @godude6950
    @godude6950 Před 5 lety +4

    Similar to the new cross report drill through feature. I would love for these buttons to be able to navigate to pages in other reports all while staying within the same . I understand the link to a web URL is possible but being able to keep it in the same would be key

  • @will1315
    @will1315 Před 5 lety

    Thank you so much for showing this! Very good method to improve UX

  • @David-ey2jf
    @David-ey2jf Před 5 lety

    I use buttons and bookmarks all the time but the invisible buttons over other content idea was new to me. I started using it today in a new report I'm building. Thanks for the tip!

  • @2404Pepe
    @2404Pepe Před 4 lety

    Great girl !!!! she is simple and knows her stuff. Thanks so much

  • @sjames1958
    @sjames1958 Před 5 lety

    Great video. One thing to feed back is embed codes can be hard to manage, it would be great if we could have a 'friendly' url instead of having to point at a report via an embed code.
    That way if a report needs to change our external users don't need to worry if the embed code changes.
    Thanks

  • @celuikivient
    @celuikivient Před 4 lety

    This is awesome ! I am defintely going to use it !

  • @mehdihammadi6145
    @mehdihammadi6145 Před 5 lety

    Thank you both

  • @PowerBITips
    @PowerBITips Před 5 lety

    If you love this Report layout, Come on over to PowerBI.Tips and download the Report here: powerbi.tips/product/layouts-microsoft-sept-2018/

  • @uniQue_XL
    @uniQue_XL Před 5 lety

    Thank you so much for the great tips!

  • @andydougy4347
    @andydougy4347 Před 5 lety

    Cheers sons crying...from happiness. This was great planning on diving into a new report using the buttons over cards.

  • @jurakovtun6763
    @jurakovtun6763 Před 2 lety

    You guys are just amazing! Still watching this in 2022 ;)

  • @gauravmore5987
    @gauravmore5987 Před 5 lety +3

    Really like the concept! I have been using plane images for bookmarks purpose but this sure seems promising.

    • @GuyInACube
      @GuyInACube  Před 5 lety +1

      Woot! Glad this was useful. 👊

  • @hasnainhaider8191
    @hasnainhaider8191 Před 3 lety

    Oh my, this was helpful. My first step in beautifying my dashboards :)

  • @sforti01
    @sforti01 Před 5 lety

    Excellent video. I laughed at the calculating dramatic pause at 6:07!

  • @rkandathil
    @rkandathil Před 5 lety +22

    It'd be great to have a button manager, so you can group them just like you can group bookmarks!

  • @SIYABONGAZUNGU
    @SIYABONGAZUNGU Před 5 lety

    Best video, Keep up the great work!!!

  • @RenatoHaddadMVP
    @RenatoHaddadMVP Před 5 lety +2

    Great video about Buttons, thanks. I would like suggest your team thinking about create a navigation panel, like a frame in web apps. you can add / remove or change any buttons in this frame. And also set the navigation panel on top or left.

  • @ziyad4u
    @ziyad4u Před 2 lety

    Great video! This is really helpful for pbi devs to improve the user experience.

  • @ajeetverma1902
    @ajeetverma1902 Před 5 lety

    Very help full video ,thanks a lot for this one information

  • @larl07
    @larl07 Před 5 lety

    AMANDA! So cool to put a face to the voice! Love your videos every month! :D

  • @thesatwikshenoy
    @thesatwikshenoy Před 5 lety +2

    Thanks a lot for this. I always used a transparent rectangle shape. Not sure if a blank button and that is the same. But this sure changes the way I use buttons now!

    • @GuyInACube
      @GuyInACube  Před 5 lety +2

      Similar concept. 👊

    • @AmandaCofsky
      @AmandaCofsky Před 5 lety +3

      The nice advantage of the buttons over rectangle shapes is that you can add the fancy hover effects. But if you don't need that, shapes definitely work as well!

    • @thesatwikshenoy
      @thesatwikshenoy Před 5 lety

      @@AmandaCofsky thanks a lot!
      Can't wait to try this out for my upcoming projects! Looking forward to more content just like this one. Cheers!

  • @smallflyDE
    @smallflyDE Před rokem

    Inspiring video! Thank you! I will try that :-)

  • @paulskuse3209
    @paulskuse3209 Před 3 lety +1

    Would love to see a selected state for a button too. We're often building two sets of buttons so that if something is conditionally selected, the button changes colour (i.e. switches to another button!). It would be great if we could just use one button for this!

  • @akshaybholee3263
    @akshaybholee3263 Před 4 lety

    now we have the new perfect feature for button, Page navigation. No need to use bookmark to navigate to pages. The buttons can be used for cool slicers now or drill down effects. i wanted to point out also if it's possible to remove the page navigation arrow below the report after publishing it so as to make the report more like an app feel.

  • @musafirq
    @musafirq Před 4 lety +1

    Awesome use of buttons...Thanks Amanda

  • @hjk01031967
    @hjk01031967 Před rokem

    I plan on playing around with this, crazy good stuff

  • @RobertJuly-so2ni
    @RobertJuly-so2ni Před 5 měsíci

    Great. Thank you. It helps me alot.

  • @channeltorontovlogs6993

    I am very excited to see the wat of discussion, lot of love for you both

  • @abhisoulstormer
    @abhisoulstormer Před 5 lety

    Absolutely love buttons and use it all the time! @Amanda i know the template is available for download too and im sure more folks would love to get the link to it :D unfortunately i downloaded it but no longer remember where from :(!
    Also a really awesome way to use the buttons is to shift between visuals for example you can show a pie chart and the data table of that pie chart using buttons which is amazingly powerful for high level + detailed information

  • @ChandooD
    @ChandooD Před 5 lety

    Awesome ideas Amanda.

  • @andreasalmen1067
    @andreasalmen1067 Před 4 lety

    Great video, thank you!

  • @kealkil4
    @kealkil4 Před 5 lety +2

    Liked the video. Not being able to set a Default Slicer value, is the issue that causes me most grief with Bookmarked Reports.

  • @samjosoff
    @samjosoff Před 5 lety +4

    Is there a how-to on how to create the rest of this beautifully professional report? It was great to understand how the buttons work. I would like to see how the "next level" Report layout is designed

  • @manojsahu-oq7ht
    @manojsahu-oq7ht Před 4 lety

    Thanks for greate info.. but here I have one question
    Do we need to add the navigation buttons in each page?

  • @Soulenergy31
    @Soulenergy31 Před 3 lety

    4:50 this part is key!!! thank you Guys in a Cube!!!!!!!!!!!!!! Love it!!

  • @Amr-Ibrahim-AI
    @Amr-Ibrahim-AI Před 5 lety

    Nice to finally see you Amanda 🙂

  • @josedacruz4058
    @josedacruz4058 Před 5 lety

    Very very useful... I was wondering how I was gonna do some interaction effects, now I wonder no more ;) Thanks!

  • @manuel_antonio_rivera_socarras

    awesome features!!!

  • @officesuperhero9611
    @officesuperhero9611 Před 5 lety +19

    Great video. I recently learned about UNCHECKING the data option for bookmarks. I think those items should be UNCHECKED by default. Also, I have created buttons by creating images, grouping them together and then placing invisible/clear buttons over them. Would love to share with you what i did with buttons. I have gotten some really good feedback from people.

  • @nandyy27
    @nandyy27 Před 4 lety

    hi, Thanks a lot for all the tutorials. Its great, please keep doing such videos. Can anyone tell me if they have created a button which can be used to export visual data (table) to csv or xl?

  • @Kmsbi
    @Kmsbi Před 4 lety

    Great video. I make beautiful Navigation menu after watching this video thanks.

  • @michaelparsons9235
    @michaelparsons9235 Před 3 lety

    This is great!!

  • @kingabullert7037
    @kingabullert7037 Před 4 lety

    This is very helpful, thank you. There is one functionality that I wish was easier in Power BI. That is enabling and disabling buttons based on the selection in visuals. For example, can I have a button that is grayed out unless I make a selection in my graph? I know there is a drill through button option with the March update, but there is no way to style the button while it's disabled - that is a major drawback of that feature.

  • @scottm6986
    @scottm6986 Před 5 lety

    This is great, thanks!

  • @prasadk5082
    @prasadk5082 Před rokem

    Absolutely.... great ideas.,.

  • @mikefong1179
    @mikefong1179 Před 5 lety

    Perfect video! Informative, quality and fun! More videos like this please! I have some feedback
    Easier way to create and manage these interaction, such as allowing users to manipulate the underlying JSON file for reusing, bulk creation and edition, and so on. Even better, we can share those metadata with others! It would open up the Power BI ecosystem even more!

  • @guusvanzuylen6501
    @guusvanzuylen6501 Před 4 lety

    Awesome examples!
    Can you please share that 2nd .pbix too?
    I love your solution of blank buttons layered over cards.

  • @angelaebirim2705
    @angelaebirim2705 Před 2 lety

    Very nice. Let's have more!

  • @WalterCalcagno
    @WalterCalcagno Před 5 lety +1

    how can I put a button into a table visualization, when the action "go to next page" for example,? just like an internal link.

  • @obimad
    @obimad Před 4 lety

    Great Video! Thanx a Lot!

  • @gxsoft
    @gxsoft Před 5 lety

    Hey! Good tricks, as always, congrats, this time, to MissAmandaN! . Thanks!, I'will follow her in twitter.
    Thanks, again
    gab

  • @mikkelmortensen3964
    @mikkelmortensen3964 Před 3 lety

    Buttons are great for navigating in reports :-) , but they could be even better if we could use them to switch between different values from a column like for example months when using a BciCalendar visual or static tables showing forecast accuracies for a single month, then click a Prev/Next button to show the previous or next month's summary, so we don't have to paste 12 visuals on top of each with bookmarks.

  • @fabricioquezada
    @fabricioquezada Před 4 lety

    Me encanto el video super instructivo

  • @Rewena789
    @Rewena789 Před 5 lety +1

    Great video and I have a question.
    When you are showing the blank button on top of a card, is that a multi-row card with different colors I'm looking at (Usage)? I didn't think that was possible. I must be missing something. Thanks :)

  • @ashwinshankar
    @ashwinshankar Před 4 lety

    Thanks Guys, this is awesome. My question is If I have 2 separate sets of buttons using bookmarks to toggle between table and chart. How do I make the bookmarks not impact the other bookmark selection

  • @pniiniko
    @pniiniko Před 4 lety

    Hi and thank for both of you for a nice and informative presentation. Just one question; after making these new buttons with their connection to bookmarks, is it possible to adapt these funktionalities in the final dashboard as a view person? Greetings, Pasi from Finland

  • @davidpanza4385
    @davidpanza4385 Před 4 lety +1

    This is great! I have created my navigation menu using pictures, directing bookmarks to each one, instead of using buttons...

    • @GuyInACube
      @GuyInACube  Před 4 lety

      Awesome! Very exciting. Glad you were able to get that sorted. Thanks for watching 👊

  • @hermesjrd
    @hermesjrd Před 5 lety +1

    Great Tips, Thank You

    • @GuyInACube
      @GuyInACube  Před 5 lety

      Most welcome! Thanks for watching. 👊

  • @BritonWells
    @BritonWells Před 5 lety +15

    Would love toggle switches - currently able to do this with 2 overlapped images right now. Use case to give users options to swap visuals (e.g. cumulative vs periodic)

    • @cybertrophic
      @cybertrophic Před 5 lety

      Briton Wells and a customisable radio button selector.

    • @anirudhacs8814
      @anirudhacs8814 Před 4 lety

      Yes please! I was searching for toggle switches too before I landed on this video

  • @RobBastien
    @RobBastien Před 4 lety

    Great stuff. I'd also like to see graphicaly pleasing U.I. landing pages, including company name, logo and tiles linking to dashboard pages.

  • @PTimbs
    @PTimbs Před 3 lety

    Very helpful

  • @elmiguel1022
    @elmiguel1022 Před 5 lety

    Hi all,
    I love your reports. Which font do you use in the visuals?
    I loved this video

  • @user-zr4kx5ow9v
    @user-zr4kx5ow9v Před 3 lety

    very good perfect topic

  • @avpr1c
    @avpr1c Před 5 lety

    Love the blank button idea. I’m going to layer it into a customer issue tracker. Question for y’all, do certain data sources load faster than others? I’ve been using Excel but is Access or SQL quicker? I’m looking to improve load speeds. My datasets aren’t even that big, sub 1000 rows

  • @dsmviolin
    @dsmviolin Před 4 lety

    Thanks! What about using slicers instead of buttons to achieve the same thing that you showed with the cards? Is there a way to use a dropdown slicer to change the visuals on the page?

  • @sudeshnasen2731
    @sudeshnasen2731 Před 2 lety

    Awesome!!!

  • @baluaadyaanju
    @baluaadyaanju Před 5 lety +1

    So we can create a dashboard kind of thing in power bi desktop as in power service,but it is actually a report.... Very nice...i learnt good stuff to day...thanks

    • @GuyInACube
      @GuyInACube  Před 5 lety +1

      From my experience, a lot of folks use a report as a dashboard. Definitely possible. 👊

  • @stephanethia
    @stephanethia Před 5 lety

    Great. In bookmark usage like you, when i have a lot bookmarks, it is unlike to have all of them in the action pane. When Microsoft will add the group level on the action button ?