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
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.
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.
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.
Here are some good examples of slicer panels. powerbi.tips/product/layouts-microsoft-sept-2018/ powerbi.tips/product/layout-cool-blue/ These are free to download and explore how I built them. Enjoy!!! More layouts and templates can be found here: powerbi.tips/layouts/
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
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.
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!
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!
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'
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.
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!
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?
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 :)
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!
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.
Thanks for the video. It saves a lot of time while we work with bookmarks for filter panel. However, I have a question Q: Are we able to bring in scrollable filter panel, which means if the user has say 20 slicers within this slicer panel, how will the user create a scrollable panel
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
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.
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.
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...
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!
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 😁
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.
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.
Hey great video. At 4:15 when you create a group I right click and get a "No available actions" showing up? Anyone got any idea where I'm going wrong? I defo have all 4 items selected.
I love your video, the normal PowerBI desktop doesn't have many visual functions like yours or even can't change the shape of slicer, do we need to download another tool to back up PowerBI desktop?
These are great thank you. I was wondering is there a way to apply these grouped slicers to multiple pages easily where everything stays on said page. Currently the back or hide button brings me back to the initial page
Thanks!
Thank you so much Prerak! 👊
2 weeks ago we started with power bi in our company. you are my new favourite human. thank you for your service.
Awww that's great to hear! Best wishes on your journey with Power BI 👊
@@GuyInACube I've also just recently started going deep into Power BI at work and your videos are great. Keep em coming!
PowerBI Date Visualization **SUPER SOLUTION**
ua-cam.com/video/1r6XMEGnau8/v-deo.html
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
Can you provide a link for reference?
GREAT idea - thank you!
@@masternoble ua-cam.com/video/5TaZQFc-t58/v-deo.html
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.
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.
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.
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.
Always use slicer panels and struggle with them reducing the usable space, this will really help, thanks!
This is a fantastic way to maximise the space of your visuals without having filters cluttering up the view! Great job!
Hi
I need to create a dashboard, could you help me pleeeease?
Here are some good examples of slicer panels.
powerbi.tips/product/layouts-microsoft-sept-2018/
powerbi.tips/product/layout-cool-blue/
These are free to download and explore how I built them.
Enjoy!!!
More layouts and templates can be found here: powerbi.tips/layouts/
Love it! Thanks for sharing as always guys! 👊
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
YES! Very true. Lots of benefits. Thanks for calling that out.
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.
Thoroughly impressed with this! You have no idea how much this helps me.
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!
It is crazy what you can do with reports :) so many hidden gems and techniques. 👊
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
Fantastic! Thanks for sharing - I was looking for ways to have more visual space. Great solution!
Love it! This is a great way to accomplish that. 👊
Awesome, easy to follow, have put into use the grouping , slicer panel and bookmark...thanks
Awesome! Exciting to hear 👊
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!
You guys are lifesavers! Saved me from a crowded list of slicers.
From one software developer to another. Well done sir, well done.
This is great! Just starting learning Power BI and you guys have the best channel so far. Love the enthusiasm!!!
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'
Knew everything shown in this video yet enjoyed the way it is explained to make it look so simple! Great guy!!!😍
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.
Really cool. I love the way this opens up the space available
This is an excellent video - all content, no fluff. Thank you!
Thanks for this tutorial. Very straight forward for the bookmark tutorial.
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!
Mind blown. Been messing with Bi on and off and learning as i go. Gonna try this now
Awesome! Thanks for watching! 👊
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!
Again, this is an awesome video, to the point and clear and boooooom you got a loyal subscriber.
You just changed my life. That was amazing.
I am a new subscriber, the explanation is awesome....it really helps me to gear up my Power bi reports... Thanks a lot!!!!
This was exactly what I was looking for. Thanks for explaining so clearly! Best subscription channel up til now! Keep up the good work!
i have never seen such an amazing and innovative trick in powerbi. Thanks to you for making this public. My blessings to you :)
"No, he's not going to do this... boom!" This was my actual reaction when realizing, what he did. @Adam, great idea!
PowerBI Date Visualization **SUPER SOLUTION**
ua-cam.com/video/1r6XMEGnau8/v-deo.html
wow...this was simply awesome .... I can now add more visuals on my report .... thanks a ton....
Thanks for this. Simple and easy to follow instructions.
Thanks for sharing this, I had to click the update option after deselecting data of the bookmark for it to work though...
Yeah it can be a little tricky sometimes.
Thank you for the tips ... I love the extra layer of interactions we can add to the report.
Most welcome! It is a nice little addition to a report 👊
Brilliant, opens up the report and works like a charm, thanks
Love to hear that! 👊
I LOVE YOU! your content always save me from a power bi chaos!
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?
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 :)
I use bookmark in most of my dashboards but I was completely unaware of the grouping feature. Great!!!
It's is pretty handle. No worries on not knowing about it. It is very new (August 2019).
@@GuyInACube Can we do that without grouping the objects, right? For those one who has not available the latest PBI versions?
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!
Fantastic, perfect feature for a project portfolio dashboard
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.
awesome guys, this is a great solution when several slicers need to fit in the screen!
Thanks for the video. It saves a lot of time while we work with bookmarks for filter panel. However, I have a question Q: Are we able to bring in scrollable filter panel, which means if the user has say 20 slicers within this slicer panel, how will the user create a scrollable panel
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!
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
Short , well explained and very valuable videos..thanks
This is soo soo good. Thank you so much for your awesome tutorials. You are my new favs in UA-cam.
Really appreciate that! Thanks for watching 👊
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.
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
DO IT! Love it! 👊
@@GuyInACube Will do for sure! Best - Henry
Fantastic idea... I made this menu with several steps, this way it was very simple
great to hear! Thanks for watching 👊
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.
mind.....blown. just starting out in BI and damn, this is good stuff!!!
Love this grouping feature. Thanks for sharing.
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...
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!
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 😁
Awesome - Congrats on reaching and surpassing 100,000 subscribers:)...Hope you keep adding zeroes with your knowledgeable videos
That's awesome technique and I REALLY love this
Just used the hide / unhide slicers in my report! Great channel!
I'm definitely using this in my next project.. gr8 piece of work
Hey, wondering to see the next level slicer panel. Excellent to learn.
Saving lot of space in page area, many many thanks !!
Really awesome video. Shared it with our Power BI community at work.
I am just learning power bi and you just made it a lot more interesting!!!
Really great walkthrough! Gonna use it to build a bookmark panel
Your videos are greeeeat! I have recently started to use PBI and I added this slicer panel, my boss loved it 🤭
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.
You are simply amazing! I love all the tips and over all your fantastic energy!
Loved it.. really good way to have more space for visuals
Amazing piece of work Adam. You made it looks so easy.. thanks for sharing such a great video..
Really helpful video, I have referenced it multiple times!
Thank you very much for good video. Well explained and simple to follow.
wow, this truly does bring my PowerBI reports to the next level! thanks for sharing!
Thank you very much Sir., kind regards from Costa Rica.
Thanks for the video, I have a question, i wanted to show the selected slicer item names(from filter pane) on the dash board?
Great stuff Adam! Was wondering how to use bookmark function
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.
Hey great video. At 4:15 when you create a group I right click and get a "No available actions" showing up? Anyone got any idea where I'm going wrong? I defo have all 4 items selected.
Exquisite! Nice videos, the only problem is powerBI is changing rapidly which makes it a little hard to find some tools and settings.
T-shirt is killing it
Appreciate that! 👊
Mind if I ask where the Tshirt is from?
I love this video, Im applying it to my work!
I enjoy the different user experience this creates. Is it *better* to use the filter pane for performance and/or other reasons?
There are pros/cons to each. Check out this video - ua-cam.com/video/njWTq3CzEBc/v-deo.html
Is there any way to share the slicer panel across tabs? Love the video btw. Easy to implement.
PowerBI Date Visualization **SUPER SOLUTION**
ua-cam.com/video/1r6XMEGnau8/v-deo.html
Great and highly relevant tip! Excellent work, guys.
I LOVE the dolls in the background! I know this guy know his stuff because of them.
I love your video, the normal PowerBI desktop doesn't have many visual functions like yours or even can't change the shape of slicer, do we need to download another tool to back up PowerBI desktop?
Great idea, certainly going to use it to help conserve screen real estate!
nice video... is there a way to share the panel across different pages in a dashboard?
Just came across your channel - videos - great stuff. Thank you!
Welcome to the Cube! Glad to have you aboard and appreciate the kind words. 👊
This is a great work guys, I was looking for this option and you've done it. Many thanks again!
Nice and clear explanation how to use slicers properly. Though, I am not really sure why you hid the Data Selection?
Thank you guys for the fantastic work, love your videos!
These are great thank you. I was wondering is there a way to apply these grouped slicers to multiple pages easily where everything stays on said page. Currently the back or hide button brings me back to the initial page
Awesome content, especially the grouping of slicers. Also thanks for the brief into to buttons.
Very cool idea! Great to give more real estate for visuals by hiding the panel. Thanks for sharing
Loved it. Works perfectly 🙌 Thank you Adam!!