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

Save more screen for your team. The pop out slicer panel is a perfect way to conserve space while building out your dashboard (i.e., reports) in Power BI desktop. You can watch me build out the slicer panel step by step using bookmarks, selection panel and buttons. Make sure to subscribe to my channel for more Power BI/Tableau tips!
★☆★ Join this channel to get access to perks: ★☆★
/ @anthonysmoak
★☆★ SUBSCRIBE TO ME ON KZbin: ★☆★
Subscribe ► / anthonysmoak
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Twitter ► / anthonysmoak
Facebook ► / anthonybsmoak
Thanks for your support!

[@natashjatroskie649]

AMAZING AMAZING THANK YOU

[@AnthonySmoak]

Thank you for the kind words!

[@lilyli8390]

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

[@AnthonySmoak]

Fantastic, glad to hear it!

[@AnthonySmoak]

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

[@danielmcphillips3776]

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

[@AnthonySmoak]

Glad you found the video useful!

[@nabarunmajumdar7197]

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

[@sands7779]

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

[@TrainGeek]

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

[@AnthonySmoak]

So glad you found value in the video!

[@debbieedwards7267]

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

[@AnthonySmoak]

Fantastic, glad to hear it!

[@wexwexexort]

Nicely explained, thnaks!

[@AnthonySmoak]

Thank you!

[@JavierMosquerajay]

This was extremely useful information! Thanks so much!

[@AnthonySmoak]

Thank you!

[@josephdaly6334]

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

[@AnthonySmoak]

Thanks for the great comment!

[@nileshhaval2666]

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]

Thanks for watching and supporting the channel Nilesh!

[@nileshhaval2666]

@@AnthonySmoak Love and Respect From India...

[@rachelsommers7168]

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

[@AnthonySmoak]

Thank you, glad to hear it!

[@ashwinshankar]

This is amazing. Thank you very much

[@natashjatroskie649]

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

[@analyst42]

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]

Glad to hear it, thank you Nathaniel!

[@valentinayusty2408]

THANKK UU!! Great explanation

[@AnthonySmoak]

Thank you!

[@rochellerobinson939]

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

[@TheRealDadJokes]

I love this, Anthony. Thank you for sharing!

[@AnthonySmoak]

Thanks for liking and commenting!

[@TheRealDadJokes]

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

[@AnthonySmoak]

@@TheRealDadJokes Glad to hear it!

[@finisterremork]

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

[@MolikCZ]

That is amazing, thank you!

[@AnthonySmoak]

Much appreciated, thanks for the comment!

[@Sophia-nb3gt]

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.

[@shreejabioinfo]

Thank you :) was very helpful

[@AnthonySmoak]

Glad to hear that!

[@wildecorrea6477]

Great video!!! Congratulations!!!

[@melcloud-solucooesemtecnol7861]

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.

[@mirrrvelll5164]

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

[@AnthonySmoak]

Glad to hear it, thank you!

[@mirrrvelll5164]

@@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]

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

[@feng3625]

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

[@AnthonySmoak]

Glad to hear it!

[@engahmedelbendary1566]

thx alot for your Effort u r Amazing

[@AnthonySmoak]

Thank you sir!

[@fionamercy2989]

Cool video. Thanks a lot.

[@AnthonySmoak]

Thanks for the comment!

[@pioafc]

Wonderful Tutorial, thank you :)

[@Mooshoa]

Love it! Thank you so much!

[@AnthonySmoak]

Thank you Masha!

[@hemanadezhdank401]

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 .

[@rvian4]

Excellent. Thanks!

[@AnthonySmoak]

Thank you!

[@wwiciii]

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]

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

[@wwiciii]

@@AnthonySmoak thanks!

[@adeelyousafMughalsOnline]

Thankyou Its really helpfull

[@AnthonySmoak]

Fantastic, glad to hear

[@Im_Thanos]

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

[@AnthonySmoak]

Much appreciated!

[@nkululekonzimande780]

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

[@AnthonySmoak]

Thanks and good catch on the 112 reference!

[@vincentfua8513]

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

[@AnthonySmoak]

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

[@dhairyatayal9945]

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

[@AnthonySmoak]

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]

@@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]

@@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]

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

[@911KC-m5r]

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

[@ParvanaGasimova]

excellent amazing thanks

[@AnthonySmoak]

You're too kind!

[@jacksonhuang7772]

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

[@AnthonySmoak]

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.

[@TheTeguhdinatazt]

thankyou

[@soumyamohapatra646]

Thanks :)

[@AnthonySmoak]

Thanks for watching!

[@laurent_bocquet]

Bright 👍

[@korkiatv]

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

[@klemetsrudj]

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

[@AnthonySmoak]

Thanks for the feedback.

[@reecelittle2441]

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

[@chandrapamidikalva3277]

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

[@AnthonySmoak]

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

[@chandrapamidikalva3277]

@@AnthonySmoak Thank you

[@davepotter7121]

awesome!

[@moninamarchadesch969]

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

[@DynamicSphinx]

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

[@thehungerhunter740]

Amazing dashboard! Can you please share the dataset

[@AnthonySmoak]

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

[@thehungerhunter740]

@@AnthonySmoak Thank you so much

[@DynamicSphinx]

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

[@arnaumartin6700]

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]

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

[@mayankpatelca]

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.

[@bomma4509]

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

[@krisadasuya7530]

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

[@AnthonySmoak]

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

[@krisadasuya7530]

@@AnthonySmoak Thank you :)

[@AnthonySmoak]

No problem Krisada!

[@sreeshinet]

Great

[@DynamicSphinx]

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]

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]

@@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]

Glad to hear it, thanks for the tip!

[@skillguru286]

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]

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

[@sarthak7960]

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

[@nabarunmajumdar7197]

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]

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]

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]

Way to hard to follow and disjointed

[@AnthonySmoak]

Nothing worth having comes easy.

[@rochellerobinson939]

Thanks! Very informative.

[@AnthonySmoak]

Thanks Rochelle!