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.
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.
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.
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
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!
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.
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.
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'
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!
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.
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.
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?
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 😁
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.
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 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?
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.
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
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?
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.
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.
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.
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
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!
As always, this is a great video. But, what is the diference with the filter pane?. I dont use yet cause a need to undestard it better. Can we do what you did in this video with the filter pane? Is there an advantadge using it? For example, in this panel are the filter that the user can use. But if i have a filter for the page or the report, in the filter pane the user can see it and may be broke the desing you did. So, may be a video showing all the pro and con will be usefull. Any way, thanks for this excelent material.
I agree.. it can also be a performance drag. It does offer nice webpage/app like UI but I would do it if there arent many/complex queries. For larger report, keep it simple. I would love to be proven wrong :)
Performance can definitely come into play. Be careful with how many slicers you put on your page. They are each a visual and will result in 1 or more queries. I always believe in keeping it simple. Taking advantage of the filter pane should also be looked at.
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**
th-cam.com/video/1r6XMEGnau8/w-d-xo.html
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.
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 th-cam.com/video/5TaZQFc-t58/w-d-xo.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.
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?
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.
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. 👊
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.
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.
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!
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!!!😍
From one software developer to another. Well done sir, well done.
You guys are lifesavers! Saved me from a crowded list of slicers.
I am a new subscriber, the explanation is awesome....it really helps me to gear up my Power bi reports... Thanks a lot!!!!
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.
This is great! Just starting learning Power BI and you guys have the best channel so far. Love the enthusiasm!!!
Mind blown. Been messing with Bi on and off and learning as i go. Gonna try this now
Awesome! Thanks for watching! 👊
You just changed my life. That was amazing.
Really cool. I love the way this opens up the space available
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 for this tutorial. Very straight forward for the bookmark tutorial.
Great video 👍 but why do you need the filter rectangel? By setting the background on the group you dont really need one anymore?
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.
This is an excellent video - all content, no fluff. Thank you!
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 - th-cam.com/video/njWTq3CzEBc/w-d-xo.html
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.
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?
Again, this is an awesome video, to the point and clear and boooooom you got a loyal subscriber.
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!
Is there any way to share the slicer panel across tabs? Love the video btw. Easy to implement.
PowerBI Date Visualization **SUPER SOLUTION**
th-cam.com/video/1r6XMEGnau8/w-d-xo.html
Fantastic, perfect feature for a project portfolio dashboard
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 😁
Great stuff Adam! Was wondering how to use bookmark function
Hey, wondering to see the next level slicer panel. Excellent to learn.
"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**
th-cam.com/video/1r6XMEGnau8/w-d-xo.html
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!
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 👊
i have never seen such an amazing and innovative trick in powerbi. Thanks to you for making this public. My blessings to you :)
Awesome - Congrats on reaching and surpassing 100,000 subscribers:)...Hope you keep adding zeroes with your knowledgeable videos
Brilliant, opens up the report and works like a charm, thanks
Love to hear that! 👊
Love this grouping feature. Thanks for sharing.
Just used the hide / unhide slicers in my report! Great channel!
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.
Thanks for this. Simple and easy to follow instructions.
Fantastic idea... I made this menu with several steps, this way it was very simple
great to hear! Thanks for watching 👊
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?
I'm definitely using this in my next project.. gr8 piece of work
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
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?
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 :)
awesome guys, this is a great solution when several slicers need to fit in the screen!
mind.....blown. just starting out in BI and damn, this is good stuff!!!
This is soo soo good. Thank you so much for your awesome tutorials. You are my new favs in TH-cam.
Really appreciate that! Thanks for watching 👊
I LOVE the dolls in the background! I know this guy know his stuff because of them.
Really great walkthrough! Gonna use it to build a bookmark panel
This was exactly what I was looking for. Thanks for explaining so clearly! Best subscription channel up til now! Keep up the good work!
Saving lot of space in page area, many many thanks !!
Short , well explained and very valuable videos..thanks
T-shirt is killing it
Appreciate that! 👊
Mind if I ask where the Tshirt is from?
Thanks for the video, I have a question, i wanted to show the selected slicer item names(from filter pane) on the dash board?
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
Your videos are greeeeat! I have recently started to use PBI and I added this slicer panel, my boss loved it 🤭
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.
That's awesome technique and I REALLY love this
I am just learning power bi and you just made it a lot more interesting!!!
Exquisite! Nice videos, the only problem is powerBI is changing rapidly which makes it a little hard to find some tools and settings.
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
wow...this was simply awesome .... I can now add more visuals on my report .... thanks a ton....
Nice and clear explanation how to use slicers properly. Though, I am not really sure why you hid the Data Selection?
I LOVE YOU! your content always save me from a power bi chaos!
Amazing piece of work Adam. You made it looks so easy.. thanks for sharing such a great video..
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?
Really awesome video. Shared it with our Power BI community at work.
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.
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.
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.
You are simply amazing! I love all the tips and over all your fantastic energy!
Thank you very much Sir., kind regards from Costa Rica.
Just came across your channel - videos - great stuff. Thank you!
Welcome to the Cube! Glad to have you aboard and appreciate the kind words. 👊
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
Loved it.. really good way to have more space for visuals
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!
Thank you very much for good video. Well explained and simple to follow.
Great Video, what version of PowerBI si this? I am using May2019 and not able to get Group option
me too, please let me know if you could get through this.
Yes me too
See this link for the solution community.powerbi.com/t5/Desktop/Grouping-visuals-not-working-no-right-click-menu/m-p/771737#M371825
Great video!! I tried the same it’s great but I have a different issue can we refresh data in multiple sheets on a single click?
As always, this is a great video. But, what is the diference with the filter pane?. I dont use yet cause a need to undestard it better. Can we do what you did in this video with the filter pane? Is there an advantadge using it? For example, in this panel are the filter that the user can use. But if i have a filter for the page or the report, in the filter pane the user can see it and may be broke the desing you did. So, may be a video showing all the pro and con will be usefull. Any way, thanks for this excelent material.
I agree.. it can also be a performance drag. It does offer nice webpage/app like UI but I would do it if there arent many/complex queries. For larger report, keep it simple. I would love to be proven wrong :)
Performance can definitely come into play. Be careful with how many slicers you put on your page. They are each a visual and will result in 1 or more queries. I always believe in keeping it simple. Taking advantage of the filter pane should also be looked at.
Great idea, certainly going to use it to help conserve screen real estate!
Really helpful video, I have referenced it multiple times!
Great, Please suggest, Almost the same data is contained in two columns of mixed type, and I want to use them in the same filter or slicer
nice video... is there a way to share the panel across different pages in a dashboard?
Awesome demo of this feature
Appreciate that! Thanks for watching 👊
This is a great work guys, I was looking for this option and you've done it. Many thanks again!