Build a Slicer Panel in Power BI and take it to the next level (2019)

[@alwaysthisnicknames]

2 weeks ago we started with power bi in our company. you are my new favourite human. thank you for your service.

[@GuyInACube]

Awww that's great to hear! Best wishes on your journey with Power BI 👊

[@JW-ho9hg]

@@GuyInACube I've also just recently started going deep into Power BI at work and your videos are great. Keep em coming!

[@sreejithpnair8973]

PowerBI Date Visualization **SUPER SOLUTION** kzbin.info/www/bejne/Z6OZiYB7fNOUq5o

[@alfredsfutterkiste7534]

Great. We build these all the time at my company. One tip to make the whole feel more put together: add a obscuring transparant rectangle that covers everything that is not the slicer panel when you open it. Like you pop open another menu for a minute. Makes the whole more app like

[@masternoble]

Can you provide a link for reference?

[@brolly414]

GREAT idea - thank you!

[@athiiammu6814]

@@masternoble kzbin.info/www/bejne/a4XEi4R8mJKna5o

[@marksmith8021]

We do this as well with the transparent rectangle. 1) it keeps users from asking how to hide the panel. 2) they don't accidentally click a visual and change its focus. We use a 3rd bookmark with a Reset default slicer options. Our filter panel generally have between 5 - 7 slicers or search boxes. When using this with the Matrix visual in particular it is useful to choose the selected visuals only (i.e Filter panel visuals) option so the drill down feature on the Matrix is not impacted.

[@philstanway7000]

Can not tell you how helpful this all is. Professional, Engaging, Exciting and Fun. My goal is to watch all you vids in the next month or so. My company is so blow away by the power of Power Bi and the work I have "hacked" together they ask me to start a team to use it for our system and for clients.

[@beyondtriggered4145]

I know this video is a year old, but I gotta say, this helped me majorly at work last week. I was asked to add a ton of filters to my visualizations and was stressing on how to fit everything on one page without losing visibility. This worked beautifuly.

[@stephengessling7645]

Adam proves again why Guy in a Cube is the GOAT. Easy to get up and running and enough explanation to understand what I'm doing.

[@robnicruby6594]

Always use slicer panels and struggle with them reducing the usable space, this will really help, thanks!

[@jamieohara4325]

This is a fantastic way to maximise the space of your visuals without having filters cluttering up the view! Great job!

[@rosamarialopezg4167]

Hi

[@rosamarialopezg4167]

I need to create a dashboard, could you help me pleeeease?

[@melissaphillips8506]

Thank you for this video. Totally saved me. Getting ready to demo a dashboard and end user requested a shape around slicers at the last minute. Then my slicers didn't work. Thanks to this video, I was able to correct. Love you guys.

[@codelemon4327]

Thoroughly impressed with this! You have no idea how much this helps me.

[@jurgenimschoot1704]

One of the best things about using groups like that is you can set up the navigation early on and your bookmarks keep on working as intended when you add more elements to the group

[@GuyInACube]

YES! Very true. Lots of benefits. Thanks for calling that out.

[@barryvankessel9674]

Hi Guys, First of all, I like your videos very much! Great channel to get up to speed with Power BI. This video helped me a great deal as my client asked me if it was possible to free up some space on the report page at the expense of the slicers. So I created a slicer panel using bookmarks, groupings and z-ordering. But not only that. From the slicer panel it is possible to select the type of report (a set of charts). Selecting the report type will not only show/hide charts on the page but show/hide slicers within the slicer panel as well. That's bananas! Thanks and keep up the good work!

[@GuyInACube]

It is crazy what you can do with reports :) so many hidden gems and techniques. 👊

[@Kermie1967]

I have been using the slicer panel since the first video. Other than space one of the advantages that I see as well is when the report is being used on a touch display. Drop downs can be difficult to navigate with a finger and the slicer panel allows the selections to be expanded out, making it easier for "big" fingers!

[@kylejoerger503]

Fantastic! Thanks for sharing - I was looking for ways to have more visual space. Great solution!

[@GuyInACube]

Love it! This is a great way to accomplish that. 👊

[@Ny_babs]

From one software developer to another. Well done sir, well done.

[@darylmoodley4194]

Awesome, easy to follow, have put into use the grouping , slicer panel and bookmark...thanks

[@GuyInACube]

Awesome! Exciting to hear 👊

[@derekgarner8524]

This is very cool and works great. The next step is to somehow either have 2 chart sizes options so the slicers dont overlap the visuals, so the visuals appear to shrink (slicers visible) and stretch (slicers hidden), or the program can scale the visuals accordingly.

[@cardplayer7130]

This is an excellent video - all content, no fluff. Thank you!

[@jfdr31]

I use slicer and groups and have seen ones with a panel and now thanks to you I’m going to incorporate panels, love the videos

[@nigelnoll3354]

You just changed my life. That was amazing.

[@jaysonmagdamit4784]

Thanks for this tutorial. Very straight forward for the bookmark tutorial.

[@BlakeC341]

You guys are lifesavers! Saved me from a crowded list of slicers.

[@SteveDPIves]

Nice and concise - this video was about half as long as the one I just watched telling me how to do the same thing, plus this showed the use of 'Grouping'

[@carrissime]

Thanks a lot for the video lesson.It is great! I am beginner and tried to use Slicer Panel on other pages in my report with duplicate page, but when I click on back button on other pages it always sent me to the first page. How I can fix it hide/show panel independently on each page?

[@alexkim7270]

This is great, and I never knew you could copy/paste formatting! Just one question tho. When you're working on multiple pages requiring the same slicers repeated, that means we gotta create n x 2 bookmarks right? I'm thinking if there are simpler ways to do it, like applying filter to all pages instead.

[@GustavoAlkmin]

This is great! Just starting learning Power BI and you guys have the best channel so far. Love the enthusiasm!!!

[@11jdstein]

Holy crap, what a great idea that's simple to implement. I have a Report I just created and distributed via Service and cringe at the amount of space taken up by the Slicers I need to show. This provides the perfect solution, thanks!

[@rakeshmurali2342]

Knew everything shown in this video yet enjoyed the way it is explained to make it look so simple! Great guy!!!😍

[@angelokailath7342]

Thanks for sharing this, I had to click the update option after deselecting data of the bookmark for it to work though...

[@GuyInACube]

Yeah it can be a little tricky sometimes.

[@narmadabachoti8782]

I am a new subscriber, the explanation is awesome....it really helps me to gear up my Power bi reports... Thanks a lot!!!!

[@bassabductor]

Really cool. I love the way this opens up the space available

[@optimistprime709]

Thanks for this. Simple and easy to follow instructions.

[@nikhilrao1266]

Again, this is an awesome video, to the point and clear and boooooom you got a loyal subscriber.

[@ArthurCoppens]

I truly believe the video presents a usefull way to allow end users to filter their data. In case you are content with reserving a part of the layout / screen / page, that would be an alternative way. A slight advantage then would be people allways see the selections they made and do not need to click on a button / image first to change filters. Anyway thank you very much for the clear presentation.

[@pranavindi7152]

wow...this was simply awesome .... I can now add more visuals on my report .... thanks a ton....

[@mwaltercpa]

It was time for me to 'class up' my dashboards! Thanks as always for the clear video and instruction. I have the panel defaulted as visible, over some 'nice to have' graphs. Great dual use of the space :)

[@tareksalha]

"No, he's not going to do this... boom!" This was my actual reaction when realizing, what he did. @Adam, great idea!

[@sreejithpnair8973]

PowerBI Date Visualization **SUPER SOLUTION** kzbin.info/www/bejne/Z6OZiYB7fNOUq5o

[@nataschalaros418]

This was exactly what I was looking for. Thanks for explaining so clearly! Best subscription channel up til now! Keep up the good work!

[@macarenazappe4485]

I LOVE YOU! your content always save me from a power bi chaos!

[@oseluenbaor7189]

Thank you very much for good video. Well explained and simple to follow.

[@janithrukshan]

This is a great work guys, I was looking for this option and you've done it. Many thanks again!

[@yelonektube]

I used these instructions to build a hiding bookmark panel because I wanted some slicers selection to remain visible for the users... Thanks a lot!

[@arefeenshamsuzzoha3937]

This is a prime tool in Power Bi for visuals! I've used z-axis layering and hiding/viewing with bookmarks to create drop down menus, tabbed tables, and menus pages.

[@kurcel52]

Short , well explained and very valuable videos..thanks

[@TheGarethLusk]

Mind blown. Been messing with Bi on and off and learning as i go. Gonna try this now

[@GuyInACube]

Awesome! Thanks for watching! 👊

[@ouatonceuponatime8850]

Thank you for the tips ... I love the extra layer of interactions we can add to the report.

[@GuyInACube]

Most welcome! It is a nice little addition to a report 👊

[@salehmuhammad6811]

Hey, wondering to see the next level slicer panel. Excellent to learn.

[@shatakshiagrawal3062]

This is soo soo good. Thank you so much for your awesome tutorials. You are my new favs in KZbin.

[@GuyInACube]

Really appreciate that! Thanks for watching 👊

[@saiyamjain9231]

i have never seen such an amazing and innovative trick in powerbi. Thanks to you for making this public. My blessings to you :)

[@jamess7033]

Thanks Adam, great video! I had seen where in other videos (more recent) you referenced a slicer panel, but was unaware of the ability to group visuals together for bookmark references - awesome!

[@LuciusSullaFelix]

Love this grouping feature. Thanks for sharing.

[@jimhubbard1770]

Is there any way to share the slicer panel across tabs? Love the video btw. Easy to implement.

[@sreejithpnair8973]

PowerBI Date Visualization **SUPER SOLUTION** kzbin.info/www/bejne/Z6OZiYB7fNOUq5o

[@scottsimpson2060]

Brilliant, opens up the report and works like a charm, thanks

[@GuyInACube]

Love to hear that! 👊

[@programaciondelamentesubco8533]

You are simply amazing! I love all the tips and over all your fantastic energy!

[@iqpili]

awesome guys, this is a great solution when several slicers need to fit in the screen!

[@St8ofmind123456]

Fantastic, perfect feature for a project portfolio dashboard

[@nupong]

That's awesome technique and I REALLY love this

[@miransh]

Hi Adam, Love the way you explained this for me who is new to Power BI, well I tried the show hide slicer button, but whats happening is that both are appearing at same time and the buttons are not responding to the way you showed in window. I followed your video and please do let me know where I am going wrong, is it sync? I used the action and dropdowns correctly. Thanks for providing solution to this Adam...

[@cannonbrawl]

Same experience - it works in PowerBI Desktop but when I publish the report to a workspace both states show simultaneously, and when you click the buttons it knows a bookmark has been selected but it doesn't produce the desired behaviour. Very frustrating!

[@ankitkhanna522]

Amazing piece of work Adam. You made it looks so easy.. thanks for sharing such a great video..

[@henryouang]

Your channel is where I want to get my channel to, except instead of PowerApps, it's PowerBI. Thanks for the info and inspiration. Best! Henry

[@GuyInACube]

DO IT! Love it! 👊

[@henryouang]

@@GuyInACube Will do for sure! Best - Henry

[@KenLoewen]

I enjoy the different user experience this creates. Is it *better* to use the filter pane for performance and/or other reasons?

[@GuyInACube]

There are pros/cons to each. Check out this video - kzbin.info/www/bejne/pJu6haRpeN94eMU

[@nathalyelias1400]

Your videos are greeeeat! I have recently started to use PBI and I added this slicer panel, my boss loved it 🤭

[@hjk01031967]

mind.....blown. just starting out in BI and damn, this is good stuff!!!

[@AllYoucanEat7]

the best channel ever

[@hilkokriel5659]

Really awesome video. Shared it with our Power BI community at work.

[@AnilSharma-sg4qw]

Saving lot of space in page area, many many thanks !!

[@basumo172]

I'm definitely using this in my next project.. gr8 piece of work

[@anthonyfernandez894]

Thank you very much Sir., kind regards from Costa Rica.

[@ADITYA1234588]

Loved it. Works perfectly 🙌 Thank you Adam!!

[@zedisdeadz]

T-shirt is killing it

[@GuyInACube]

Appreciate that! 👊

[@ob5773]

Mind if I ask where the Tshirt is from?

[@joychoi5126]

Thank you for this great tutorials! I have tried this to my dashboard at work and I found an issue with this slicer panel - when we open the slicer panel and choose some of the slicers and close the slicer to apply, the dashboard always goes back to the first page (without any slicers selected) as it was a fixed bookmark page. I am wondering whether I missed something else. Can anyone please share your experience and suggestions on this and how you did it?

[@sandeepadapa4848]

Great video, really taking power bi capabilities to next level, I did work on slicer pane, but I didn’t know the grouping functionality. Thanks!

[@prateeksharma-ig5qg]

Hello sir greetings!! Was adding a shape and dragged my slicers on it but now i can not access my slicers, when i click on a slicer it is selecting the shape instead.. Will be thankful to recieve help. Thanks

[@rajnanannat8421]

The slicer and group feature is already available in WebFOCUS 8.1 reporting object itself and you can tweak it as collapsible as needed when you integrate with portal and much more is possible.

[@stianbranden6612]

Great video 👍 but why do you need the filter rectangel? By setting the background on the group you dont really need one anymore?

[@GuyInACube]

Great point! You can go either way. Setting the group background makes it a bit easier and reduces the number of elements. I should have called that out.

[@Pa1KumarSistla]

Awesome - Congrats on reaching and surpassing 100,000 subscribers:)...Hope you keep adding zeroes with your knowledgeable videos

[@ggamboa75]

I am just learning power bi and you just made it a lot more interesting!!!

[@JM-eq3sx]

In a very basic Power BI report, I use two slicers for selecting Initiatives and KPI's that we track. The first slicer is a checkbox list of numbered Initiatives. The subordinate slicer is a checkbox list for selecting Key Performance Indicator (KPI) #s within the Initiatives. Each Initiative may have one or several KPIs. If I select GOAL #12345 it filters the KPI #s to the only choices for that Initiative. In this case, the only KPI is #45678. I then need to select KPI #45678 (under Goal #12345). When the KPI is selected, the report shows a text description of the KPI's measures, and several charts that measure budget, adoption rate, etc... All good. However -- when I select a NEW Goal #12346, a new list of KPIs appears in the KPI slicer, but the previously selected KPI #45678 still remains - selected - in the slicer list. When I select one of the new Initiative's KPIs, the old Initiative's KPI #45678 disappears. However the new selected KPI persists the same way as the previous one did, when the next Initiative is selected. I have used a bookmark to reset the report, but it seems unnecessary and it requires the extra "ctrl-click" for the user. The new Goal should filter out the old Initiative's KPI, but it doesn't. Any suggestions? Thanks in advance.

[@alialbayati9368]

Very helpful Adam 👌, thanks for sharing 👍.

[@erhaneren2122]

This is excellent, excellent, excellent. Thank you very much.

[@michaniedospia4100]

Just used the hide / unhide slicers in my report! Great channel!

[@pedro_ha_faria]

Great and highly relevant tip! Excellent work, guys.

[@kaifirschau]

Thank you guys for the fantastic work, love your videos!

[@annetteparisi1584]

Really helpful video, I have referenced it multiple times!

[@iamaamirkhan.]

I recently started with Power BI Your channel is awesome. Topics covered are very detailed. Helping me a lot to learn and apply your cool tricks. Thanks #GuyInACube 😁

[@goingfurther8092]

wow, this truly does bring my PowerBI reports to the next level! thanks for sharing!

[@mariaa9754]

Thanks a lot! It's really helpful. Keep up the good work!

[@iamnishant26]

Love what you guys do !!! This is so helpful

[@Andrew-jt6lh]

This is awesome! Already added it to many of my reports but I do have one problem...if you click within the filter box but not on one of the slicers it will cover up all slicers with the box. I’ve tried moving things around in the selection pane but it didn’t work. Is there any way to disable “clickability” of a visual to avoid this? Thanks!

[@nizlopist]

Awesome content, especially the grouping of slicers. Also thanks for the brief into to buttons.

[@AnalyzeIt_Nael]

This is a great video. Thanks for teaching us how to combine grouping and bookmark features for slicing data

[@GuyInACube]

Love it! It can definitely be used in more ways than just a slicer panel. Great option to keep in your tool belt 👊

[@johnherndon9040]

I LOVE the dolls in the background! I know this guy know his stuff because of them.

[@frankthetankfrombavaria]

Really great walkthrough! Gonna use it to build a bookmark panel

[@sandrofdigital]

Fantastic idea... I made this menu with several steps, this way it was very simple

[@GuyInACube]

great to hear! Thanks for watching 👊

[@ashishshrestha7179]

Loved it.. really good way to have more space for visuals

[@AHMEDALDAFAAE1]

Nice and clear explanation how to use slicers properly. Though, I am not really sure why you hid the Data Selection?

[@Mr_MicDaniel]

Thank you for this awesome lesson but I have got a problem with it, I copied and paste my menu bar in my different page when I try to show the slicer panel it takes me back to the page I created the panel....how do I resolve this

[@RameshPennam]

Hey, did you solve this problem? if yes please can you tell me what did you do?

[@stockfish2826]

Exquisite! Nice videos, the only problem is powerBI is changing rapidly which makes it a little hard to find some tools and settings.

[@raybloodypurchase1941]

Hi Adam, I wanted to ask if there was a way to customise a slicer button by specifying what the button would pull up once clicked? In this case I have 3 sets of project milestones that I would like to apply to three seperate buttons? Appreciate your videos as always.

[@SaurabhOlkarSAN]

Hello, both of you are amazing in deciphering things, learning a lot from you both. In this particular session, just wanted to check one thing when we uncheck the Data option for each of the Bookmarks do we have to Update option as well in order to apply the setting, please shed some light

[@VikasChaudhary1]

Great Video, what version of PowerBI si this? I am using May2019 and not able to get Group option

[@pallavnathany5907]

me too, please let me know if you could get through this.

[@chiragkhuranaa]

Yes me too

[@yaakovweldler9346]

See this link for the solution community.powerbi.com/t5/Desktop/Grouping-visuals-not-working-no-right-click-menu/m-p/771737#M371825

[@sylau1516]

Thanks. Good guidance given. Wonder if u can advice as I can't seem to put the same slicer panel on another page as it keeps going back to the original page. Is there anything I can do about this? Appreciate your advice.