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

Подписаться 23 тыс.

Просмотров 57 тыс.

50% 1

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 RU-vid: ★☆★
Subscribe ► / anthonysmoak
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Twitter ► / anthonysmoak
Facebook ► / anthonybsmoak
Thanks for your support!

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 121

@natashjatroskie649 4 года назад

AMAZING AMAZING THANK YOU

@AnthonySmoak 4 года назад

Thank you for the kind words!

@AnthonySmoak 4 года назад

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

@lilyli8390 10 месяцев назад

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

@AnthonySmoak 10 месяцев назад

Fantastic, glad to hear it!

@shreejabioinfo 7 месяцев назад

Thank you :) was very helpful

@AnthonySmoak 4 месяца назад

Glad to hear that!

@engahmedelbendary1566 2 года назад

thx alot for your Effort u r Amazing

@AnthonySmoak 2 года назад

Thank you sir!

@natashjatroskie649 4 года назад

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

@debbieedwards7267 3 года назад

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

@AnthonySmoak 3 года назад

Fantastic, glad to hear it!

@nabarunmajumdar7197 4 года назад

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

@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

@rachelsommers7168 4 года назад

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

@AnthonySmoak 4 года назад

Thank you, glad to hear it!

@TheTeguhdinatazt 3 года назад

thankyou

@ashwinshankar 3 года назад

This is amazing. Thank you very much

@fionamercy2989 2 года назад

Cool video. Thanks a lot.

@AnthonySmoak 2 года назад

Thanks for the comment!

@rochellerobinson939 3 года назад

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

@TrainGeek 7 месяцев назад

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

@AnthonySmoak 6 месяцев назад

So glad you found value in the video!

@adeelyousafMughalsOnline 3 года назад

Thankyou Its really helpfull

@AnthonySmoak 3 года назад

Fantastic, glad to hear

@valentinayusty2408 2 года назад

THANKK UU!! Great explanation

@AnthonySmoak 2 года назад

Thank you!

@JavierMosquerajay 2 года назад

This was extremely useful information! Thanks so much!

@AnthonySmoak 2 года назад

Thank you!

@nileshhaval2666 3 года назад

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 3 года назад

Thanks for watching and supporting the channel Nilesh!

@nileshhaval2666 3 года назад

@@AnthonySmoak Love and Respect From India...

@danielmcphillips3776 3 года назад

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

@AnthonySmoak 3 года назад

Glad you found the video useful!

@mirrrvelll5164 2 месяца назад

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

@AnthonySmoak 2 месяца назад

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

@ParvanaGasimova Месяц назад

excellent amazing thanks

@AnthonySmoak 24 дня назад

You're too kind!

@analyst42 4 года назад

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 4 года назад

Glad to hear it, thank you Nathaniel!

@feng3625 3 года назад

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

@AnthonySmoak 3 года назад

Glad to hear it!

@soumyamohapatra646 3 года назад

Thanks :)

@AnthonySmoak 3 года назад

Thanks for watching!

@MolikCZ 2 года назад

That is amazing, thank you!

@AnthonySmoak 2 года назад

Much appreciated, thanks for the comment!

@josephdaly6334 3 года назад

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

@AnthonySmoak 3 года назад

Thanks for the great comment!

@melcloud-solucooesemtecnol7861 4 года назад

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.

@finisterremork 3 года назад

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

@Sophia-nb3gt 3 года назад

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.

@laurent_bocquet Год назад

Bright 👍

@wexwexexort 2 года назад

Nicely explained, thnaks!

@AnthonySmoak 2 года назад

Thank you!

@klemetsrudj 2 года назад

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

@AnthonySmoak 2 года назад

Thanks for the feedback.

@TheRealDadJokes 3 года назад

I love this, Anthony. Thank you for sharing!

@AnthonySmoak 3 года назад

Thanks for liking and commenting!

@TheRealDadJokes 3 года назад

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

@AnthonySmoak 3 года назад

@@TheRealDadJokes Glad to hear it!

@wildecorrea6477 4 года назад

Great video!!! Congratulations!!!

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

@Im_Thanos 4 года назад

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

@AnthonySmoak 4 года назад

Much appreciated!

@pioafc 3 года назад

Wonderful Tutorial, thank you :)

@Mooshoa 3 года назад

Love it! Thank you so much!

@AnthonySmoak 3 года назад

Thank you Masha!

@rvian4 3 года назад

Excellent. Thanks!

@AnthonySmoak 3 года назад

Thank you!

@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

@911KC-m5r 3 года назад

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

@wwiciii 2 года назад

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 2 года назад

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

@wwiciii 2 года назад

@@AnthonySmoak thanks!

@vincentfua8513 3 года назад

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

@AnthonySmoak 3 года назад

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

@nkululekonzimande780 4 года назад

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

@AnthonySmoak 4 года назад

Thanks and good catch on the 112 reference!

@davepotter7121 3 года назад

awesome!

@sreeshinet 4 года назад

Great

@reecelittle2441 Год назад

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

@moninamarchadesch969 2 года назад

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

@jacksonhuang7772 2 года назад

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

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

@dhairyatayal9945 3 года назад

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

@AnthonySmoak 3 года назад

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 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 3 года назад

@@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 3 года назад

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

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

@sarthak7960 3 года назад

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

@krisadasuya7530 2 года назад

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

@AnthonySmoak 2 года назад

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

@krisadasuya7530 2 года назад

@@AnthonySmoak Thank you :)

@AnthonySmoak 2 года назад

No problem Krisada!

@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 2 года назад

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

@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 4 года назад

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

@thehungerhunter740 3 года назад

Amazing dashboard! Can you please share the dataset

@AnthonySmoak 3 года назад

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

@thehungerhunter740 3 года назад

@@AnthonySmoak Thank you so much

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

@chandrapamidikalva3277 3 года назад

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

@AnthonySmoak 3 года назад

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

@chandrapamidikalva3277 3 года назад

@@AnthonySmoak Thank you

@DynamicSphinx 4 года назад

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 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 4 года назад

@@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 4 года назад

Glad to hear it, thanks for the tip!

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