Build a Power BI Pop Out Slicer Panel (Step by Step Instructions)

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

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

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

    AMAZING AMAZING THANK YOU

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      Thank you for the kind words!

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

    This is what I'm looking for. Thank you Anthony.👍👍👍

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

      Fantastic, glad to hear it!

  • @AnthonySmoak
    @AnthonySmoak  4 ปีที่แล้ว +10

    Some shortcuts when you need to review:
    Atlanta!! 0:00
    Dashboard Overview 0:21
    Start Pop Out Slicer Instruction 3:10
    Slicers 7:36
    Buttons 9:33
    Bookmarks 11:21
    Opaque Screen Technique 15:30

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

    THANKK UU!! Great explanation

  • @TrainGeek
    @TrainGeek 9 หลายเดือนก่อน +1

    Fantastic video, well explained. Well done. Thank you!

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

      So glad you found value in the video!

  • @sands7779
    @sands7779 4 ปีที่แล้ว

    appreciate the way you clearly demonstrate all the steps and also giving credit to haven consulting and guys in a cube as well

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

    Hey, this was a fantastic video. I understood each step completely. None of the other videos out there are so explanatory.

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

    This was extremely useful information! Thanks so much!

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

    Thank you for the step by step instruction ! Was looking for this :)

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

      Glad you found the video useful!

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

    this video is awesome! Just used it for a client's project

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      Thank you, glad to hear it!

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

    Used this for my latest project and it looks really great. thank you

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

      Fantastic, glad to hear it!

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

    That's a Brilliant Work Anthony,
    I really apricate your effort from bottom of my heart, Please share such videos more so that we can learn such techniques...!

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

      Thanks for watching and supporting the channel Nilesh!

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

      @@AnthonySmoak Love and Respect From India...

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

    Wow - this is great. Super easy to understand. Thanks so much!

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

      Thanks for the great comment!

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

    Gotta do another Shout Out as this really changed things up for me

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

    Nicely explained, thnaks!

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

    Nice work - made my job a lot easier today - thanks!

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

    I love this, Anthony. Thank you for sharing!

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

      Thanks for liking and commenting!

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

      @@AnthonySmoak Sure thing. It was exactly what I needed and you explained it really well ☺️

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      @@TheRealDadJokes Glad to hear it!

  • @shreejabioinfo
    @shreejabioinfo 9 หลายเดือนก่อน +1

    Thank you :) was very helpful

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

      Glad to hear that!

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

    Great video!!! Congratulations!!!

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

    That is amazing, thank you!

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

      Much appreciated, thanks for the comment!

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

    This was a very good tutorial, easy to follow and replicate.

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

    Thank you, Anthony, this is awesome! This is the clearest explanation of how to do this that I have seen to date, and I think the process just clicked for me fully for the first time. You just earned a new subscriber! Much appreciated 😁

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      Glad to hear it, thank you Nathaniel!

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

    Wonderful Tutorial, thank you :)

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

    Biggg Shout out to you Sir.. Great video 👏👏👏

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

    Cool video. Thanks a lot.

  • @Sophia-nb3gt
    @Sophia-nb3gt 3 ปีที่แล้ว +1

    Great video. Thanks for the detailed step by step instructions on how to create a pop-out slicer panel. Can I ask how can I apply this slicer panel to others pages? Thanks.

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

    Love it! Thank you so much!

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

    thx alot for your Effort u r Amazing

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

    Thanks! Very informative.

  • @melcloud-solucooesemtecnol7861
    @melcloud-solucooesemtecnol7861 4 ปีที่แล้ว +1

    Anthony, dude this video help me a lot of ! I'm very happyness because this video, help me on the my repport on work! Thanks.

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

    Excellent. Thanks!

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

    Thankyou Its really helpfull

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

      Fantastic, glad to hear

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

    Very good and I apply it to my report and awesome! appreciate and thank you.

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

    Wonderful message. Thanks for providing step by step option. Curious to know, if it is feasible to have apply as a button similar to clear and have all the sliced data applied all together to the visuals. please let know, if it is feasible .

  • @mirrrvelll5164
    @mirrrvelll5164 4 หลายเดือนก่อน +1

    Great to follow this. I managed to do it/implement it into my report. Thanks and you got +1 new sub =)

    • @AnthonySmoak
      @AnthonySmoak  4 หลายเดือนก่อน +1

      Glad to hear it, thank you!

    • @mirrrvelll5164
      @mirrrvelll5164 3 หลายเดือนก่อน

      @@AnthonySmoak Ah one more question, for my confirmation, what about if I wanna apply the same logic on more than one page? Does it need to be created again with the same procedure/selections/bookmarks, or is there any kind of "copy-paste" behind it? Maybe in grouping and copying the selections, I saw it is possible to copy groups that you created before.

    • @AnthonySmoak
      @AnthonySmoak  3 หลายเดือนก่อน

      @@mirrrvelll5164 As far as I know you have to manually repeat the same process with new bookmarks. community.fabric.microsoft.com/t5/Desktop/Bookmarks-can-I-make-them-work-for-a-new-page-and-not-the/m-p/564714#M266488

  • @nkululekonzimande780
    @nkululekonzimande780 4 ปีที่แล้ว

    Great Video! Definitely implementing this technique in all my reports p.s. loved the 112 reference

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      Thanks and good catch on the 112 reference!

  • @911KC-m5r
    @911KC-m5r 3 ปีที่แล้ว +1

    this is amazing! thank you, is there anyway to easily replicate to other tabs too?

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

    Hi Thanks so much! it's really helpful. i have a question. how do you apply the same thing to different report? what is the fastest way? can we copy/paste everything?

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

      Unfortunately you have to recreate the process for each report. Last i checked, duplicating the report will not work. Thanks for the comment.

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

      @@AnthonySmoak thanks!

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

    Thanks :)

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

    Great video! Is there a way to sync slicer panels on multiple pages in the same Power BI workbook?

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

      You can sync slicers across multiple pages if that is your question. Check the section named "Sync and use slicers on other pages". docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

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

      @@AnthonySmoak Thank you for your response. I am trying to have the same slicer panel on other pages within the same workbook, but when I use Show Slicer bookmark, it keeps redirecting me to the original page where slicer panel was first used. Is there a way to solve this?

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

      @@dhairyatayal9945 I assume you duplicated a tab so you don't have to rebuild the slicer panel. That duplicated slicer panel is tied to the original bookmarks. You may have to rebuild a fresh new slicer panel for each new individual page.

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

      @@AnthonySmoak Yes, that’s the solution I made. I just hoped there was a more efficient way to do it. Thank you! I appreciate your response.

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

    thankyou

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

    this tutorial amazing, thanks.. but why I need to press ctrl+click to activate the bookmark action?

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

      Thanks for the comment. Hope this helps. community.powerbi.com/t5/Desktop/Triggering-bookmark-linked-images-without-holding-Ctrl/td-p/462465

  • @ParvanaGasimova
    @ParvanaGasimova 3 หลายเดือนก่อน +1

    excellent amazing thanks

    • @AnthonySmoak
      @AnthonySmoak  3 หลายเดือนก่อน

      You're too kind!

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

    Bright 👍

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

    awesome!

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

    I would have grouped the selections as well. It makes it easier to manage.

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

      Thanks for the feedback.

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

    Amazing video! I tried to update the bookmark but it didn't work. Do you know how to fix it? Thanks!

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

      Its very hard to diagnose without knowing much about the particular setup. Just watch the video closely, there could be a step you're missing.

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

    This is great tutorial, I got an idea to visualize my report
    ps your voice is loud sometime in the video, that scared me haha

  • @chandrapamidikalva3277
    @chandrapamidikalva3277 4 ปีที่แล้ว

    Hi Very nice video, Thanks for that.
    Is there anyway to down load this report?

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      I haven't made this dashboard available but the dataset can be found online.

    • @chandrapamidikalva3277
      @chandrapamidikalva3277 4 ปีที่แล้ว

      @@AnthonySmoak Thank you

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

    Great

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

    Amazing dashboard! Can you please share the dataset

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

      I think the data can be found here: docs.microsoft.com/en-us/power-bi/create-reports/sample-financial-download

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

      @@AnthonySmoak Thank you so much

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

    How do you do the 'YoY Profit Difference' visual?

  • @arnaumartin6700
    @arnaumartin6700 4 ปีที่แล้ว

    Hi! Awesome! I followed step by step everything and works great! Just one Q... I copy pasted the pop out in another page but when I press clearly filter no only cleans all pages (I clicked synchro) but also returns to the original page. Is there any way to avoid that? Thanks in advance!

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

      Hi Arnau, I am facing the same issue. Did you find a solution yet?

  • @DynamicSphinx
    @DynamicSphinx 4 ปีที่แล้ว

    Is there a way to have this pop-out filter "floating", so that it's still available as you scroll down the dashboard?

  • @mayankpatelca
    @mayankpatelca 4 ปีที่แล้ว

    Hey Anthony... this is amazing tutorial video. I could successfully create the pop out slicer for my report. Just one problem I face is when I pin the report to my dashboard, the pop out slicer doesn't work in dashboard. If you can please help me with this. Thanks a lot.

  • @DynamicSphinx
    @DynamicSphinx 4 ปีที่แล้ว

    Would it be possible to get a download of the .pbix file? Thank you for the awesome video! I am trying to follow along :)

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

    Do you press CTRL+ Hide / Show / Clear? Why do I need to click CTRL+ for the Hide/Show/Clear buttons to respond?

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

    What was the name of Visualiztion of YoY profit chart ? Thank you.

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

      docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-basic-area-chart

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

      @@AnthonySmoak Thank you :)

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

      No problem Krisada!

  • @skillguru286
    @skillguru286 4 ปีที่แล้ว

    Can we create pop up which will show a sheet details in power BI just like tool tip? Tool tip is for just to hover and get but i want pop up which will be close after clicking on it

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      If there is a way to do that, I am not aware of it.

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

    Can we configure a POP UP Window for particular on click Button , opens a WEB URL but that WEB URL should open as a POP UP,
    Need a popoup window, don't want to see the WEB URL
    Kindly, advice on this in power BI Report server

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

    I followed along this video and created this pop-out filter, but whenever I accidentally click on the text box after expanding the filter pane it covers up all the filters and whenever I hover over the filter pane this text box keeps covering up everything on hover. Has anybody come across this issue when using this pop - out filter technique? Any suggested fix to this issue would be highly appreciated! Thank you

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      I know what you mean, I mention in the video that items should fully cover the text box so you can't touch the underlying text box. That's how I get around it. Also make sure to use "Send backwards" so your textbox stays underneath.

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

      @@AnthonySmoak Hey Anthony, I found a fix to this issue. Instead of a text box for the slicer panel, we can replace that with a blank button and set the "Show Slicer" action to the button. It works perfectly with that change. Thanks again for this video, I was really able to impress my boss with this :)

    • @AnthonySmoak
      @AnthonySmoak  4 ปีที่แล้ว

      Glad to hear it, thanks for the tip!

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

    Why I have always press ctrl while clicking on button?
    it means CTRL+ Button

  • @nabarunmajumdar7197
    @nabarunmajumdar7197 4 ปีที่แล้ว

    Can I also request you to upload a video that would also enable me to change the data item on the visuals. lets say I changed the data item A to data item B using the above slicer-bookmark technique. Another example: I changed the a visual which formerly was YOY to YTD using the above approach. (taking into account we have made the 2 measures YOY and YTD previously)

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

    Hello, First of all: thanks for the great video. Very easy to follow!
    But, I have a question: what's the easiest way to replicate this to all pages of my report? I understand that if I just duplicate the page, the bookmark will bring me back to the original page, right?

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

      Last I checked, it's a manual process to apply this technique to additional reports. Can you duplicate and create new bookmarks to assign to the objects?

  • @Cavalier70
    @Cavalier70 4 หลายเดือนก่อน

    Way to hard to follow and disjointed

    • @AnthonySmoak
      @AnthonySmoak  4 หลายเดือนก่อน

      Nothing worth having comes easy.

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

    This is amazing. Thank you very much