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.
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!
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 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!
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?
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'
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!
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.
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.
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!
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 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.
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.
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
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?
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.
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.
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
This is great! I find the slicers really intuitive for the end user but at the same time they take up space on the page. I was wondering if there is a quick way to implement this across several pages? Or do you have to copy and paste the visuals, and then recreate the bookmarks and change the action of the visuals every time? Cheers!
As always another top tip and great video. Upon publishing my report to the Service the selection and layer order is not honoured :( any further tips to get around this?
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
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 awsome! Thanks alot alot of videos do not show such an advanced level .. i actualliy have tried it several times,but i always get a challange with hold ctrl. on the butoon. it does not do any function. i click with hold ctrol on the button but it can not either disappear or show the slicer panel .. i do not know what is the problem, i have done all ur steps
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!
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**
ruclips.net/video/1r6XMEGnau8/видео.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 ruclips.net/video/5TaZQFc-t58/видео.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.
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.
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.
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 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?
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. 👊
Thoroughly impressed with this! You have no idea how much this helps me.
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 - ruclips.net/video/njWTq3CzEBc/видео.html
Always use slicer panels and struggle with them reducing the usable space, this will really help, thanks!
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.
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
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!
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?
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'
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!
Knew everything shown in this video yet enjoyed the way it is explained to make it look so simple! Great guy!!!😍
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.
From one software developer to another. Well done sir, well done.
You guys are lifesavers! Saved me from a crowded list of slicers.
Awesome, easy to follow, have put into use the grouping , slicer panel and bookmark...thanks
Awesome! Exciting to hear 👊
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.
nice video... is there a way to share the panel across different pages in a dashboard?
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 this tutorial. Very straight forward for the bookmark tutorial.
I'm definitely using this in my next project.. gr8 piece of work
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!
Is there any way to share the slicer panel across tabs? Love the video btw. Easy to implement.
PowerBI Date Visualization **SUPER SOLUTION**
ruclips.net/video/1r6XMEGnau8/видео.html
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.
Thanks for the video, I have a question, i wanted to show the selected slicer item names(from filter pane) on the dash board?
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. 👊
This is great! Just starting learning Power BI and you guys have the best channel so far. Love the enthusiasm!!!
This is an excellent video - all content, no fluff. Thank you!
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!
Mind blown. Been messing with Bi on and off and learning as i go. Gonna try this now
Awesome! Thanks for watching! 👊
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?
Thanks for this. Simple and easy to follow instructions.
Really cool. I love the way this opens up the space available
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.
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
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.
Short , well explained and very valuable videos..thanks
Your videos are greeeeat! I have recently started to use PBI and I added this slicer panel, my boss loved it 🤭
awesome guys, this is a great solution when several slicers need to fit in the screen!
Great stuff Adam! Was wondering how to use bookmark function
Again, this is an awesome video, to the point and clear and boooooom you got a loyal subscriber.
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 😁
That's awesome technique and I REALLY love this
You just changed my life. That was amazing.
i have never seen such an amazing and innovative trick in powerbi. Thanks to you for making this public. My blessings to you :)
I LOVE YOU! your content always save me from a power bi chaos!
Great video... will this work on mobile layout?
Unfortunately, no. :(
Guy in a Cube is there any alternate for the same that fits the mobile layout use case which you could recommend?
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.
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
Brilliant, opens up the report and works like a charm, thanks
Love to hear that! 👊
Nice feature for saving space on the page !
We've been using it, but now want to use the functionality on synced slicers, is that even possible ?
Just used the hide / unhide slicers in my report! Great channel!
Love this grouping feature. Thanks for sharing.
could you please upload the dataset which you are using as well? and the report too. Thanks
Thank you very much for good video. Well explained and simple to follow.
Saving lot of space in page area, many many thanks !!
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
wow...this was simply awesome .... I can now add more visuals on my report .... thanks a ton....
Fantastic, perfect feature for a project portfolio dashboard
Really helpful video, I have referenced it multiple times!
Thank you very much Sir., kind regards from Costa Rica.
Hey, wondering to see the next level slicer panel. Excellent to learn.
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?
This was exactly what I was looking for. Thanks for explaining so clearly! Best subscription channel up til now! Keep up the good work!
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
I love this video, Im applying it to my work!
Good video. I want to have slicer not as combo or check box but more a sliding thing, how to do it?
There are some slicers that have that. Relative date slicer is one that comes to mind. There may be some other custom visuals that allow it.
Very helpful Adam 👌, thanks for sharing 👍.
mind.....blown. just starting out in BI and damn, this is good stuff!!!
"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**
ruclips.net/video/1r6XMEGnau8/видео.html
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.
Fantastic idea... I made this menu with several steps, this way it was very simple
great to hear! Thanks for watching 👊
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.
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
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?
This is great! I find the slicers really intuitive for the end user but at the same time they take up space on the page.
I was wondering if there is a quick way to implement this across several pages? Or do you have to copy and paste the visuals, and then recreate the bookmarks and change the action of the visuals every time? Cheers!
Did you get an answer to this?
Exquisite! Nice videos, the only problem is powerBI is changing rapidly which makes it a little hard to find some tools and settings.
Really awesome video. Shared it with our Power BI community at work.
Really great walkthrough! Gonna use it to build a bookmark panel
Loved it.. really good way to have more space for visuals
As always another top tip and great video. Upon publishing my report to the Service the selection and layer order is not honoured :( any further tips to get around this?
My issue is now fixed, i re-installed Desktop and this resolved my issue
nice i just built this, also learned about the selection panel
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
Hey, did you solve this problem? if yes please can you tell me what did you do?
I am just learning power bi and you just made it a lot more interesting!!!
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 am not able to get those filters inside the selection pane/rectangle. How can I do that? 3:54 sec
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!
T-shirt is killing it
Appreciate that! 👊
Mind if I ask where the Tshirt is from?
Awesome - Congrats on reaching and surpassing 100,000 subscribers:)...Hope you keep adding zeroes with your knowledgeable videos
Nice and clear explanation how to use slicers properly. Though, I am not really sure why you hid the Data Selection?
Amazing piece of work Adam. You made it looks so easy.. thanks for sharing such a great video..
this is awsome! Thanks alot
alot of videos do not show such an advanced level .. i actualliy have tried it several times,but i always get a challange with hold ctrl. on the butoon. it does not do any function. i click with hold ctrol on the button but it can not either disappear or show the slicer panel .. i do not know what is the problem, i have done all ur steps
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 :)