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

  Рет қаралды 850,503

Guy in a Cube

Guy in a Cube

Күн бұрын

Adam looks at how you can build a slicer panel, in Power BI, and take it to the next level. Using a combination of features in Power BI Desktop, you can make a great user experience.
Guy in a Cube courses: guyinacu.be/courses
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com/tools/
#PowerBI #SlicerPanel #GuyInACube

Пікірлер: 727
@alwaysthisnicknames
@alwaysthisnicknames 4 жыл бұрын
2 weeks ago we started with power bi in our company. you are my new favourite human. thank you for your service.
@GuyInACube
@GuyInACube 4 жыл бұрын
Awww that's great to hear! Best wishes on your journey with Power BI 👊
@JW-ho9hg
@JW-ho9hg 3 жыл бұрын
@@GuyInACube I've also just recently started going deep into Power BI at work and your videos are great. Keep em coming!
@sreejithpnair8973
@sreejithpnair8973 3 жыл бұрын
PowerBI Date Visualization **SUPER SOLUTION** kzfaq.info/get/bejne/Z9hmi7B2rNTFpWw.html
@nataschalaros418
@nataschalaros418 3 жыл бұрын
This was exactly what I was looking for. Thanks for explaining so clearly! Best subscription channel up til now! Keep up the good work!
@philstanway7000
@philstanway7000 3 жыл бұрын
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.
@GustavoAlkmin
@GustavoAlkmin 4 жыл бұрын
This is great! Just starting learning Power BI and you guys have the best channel so far. Love the enthusiasm!!!
@bassabductor
@bassabductor 4 жыл бұрын
Really cool. I love the way this opens up the space available
@jamess7033
@jamess7033 2 жыл бұрын
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!
@jfdr31
@jfdr31 3 жыл бұрын
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
@robnicruby6594
@robnicruby6594 4 жыл бұрын
Always use slicer panels and struggle with them reducing the usable space, this will really help, thanks!
@kylejoerger503
@kylejoerger503 4 жыл бұрын
Fantastic! Thanks for sharing - I was looking for ways to have more visual space. Great solution!
@GuyInACube
@GuyInACube 4 жыл бұрын
Love it! This is a great way to accomplish that. 👊
@beyondtriggered4145
@beyondtriggered4145 3 жыл бұрын
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.
@programaciondelamentesubco8533
@programaciondelamentesubco8533 3 жыл бұрын
You are simply amazing! I love all the tips and over all your fantastic energy!
@kaifirschau
@kaifirschau 3 жыл бұрын
Thank you guys for the fantastic work, love your videos!
@cardplayer7130
@cardplayer7130 3 жыл бұрын
This is an excellent video - all content, no fluff. Thank you!
@ankitkhanna522
@ankitkhanna522 3 жыл бұрын
Amazing piece of work Adam. You made it looks so easy.. thanks for sharing such a great video..
@nizlopist
@nizlopist 4 жыл бұрын
Awesome content, especially the grouping of slicers. Also thanks for the brief into to buttons.
@saiyamjain9231
@saiyamjain9231 4 жыл бұрын
i have never seen such an amazing and innovative trick in powerbi. Thanks to you for making this public. My blessings to you :)
@hulltrueblue
@hulltrueblue 4 жыл бұрын
This is so helpful - and explained perfectly - thank you!
@rakeshmurali2342
@rakeshmurali2342 2 жыл бұрын
Knew everything shown in this video yet enjoyed the way it is explained to make it look so simple! Great guy!!!😍
@ouatonceuponatime8850
@ouatonceuponatime8850 4 жыл бұрын
Thank you for the tips ... I love the extra layer of interactions we can add to the report.
@GuyInACube
@GuyInACube 4 жыл бұрын
Most welcome! It is a nice little addition to a report 👊
@codelemon4327
@codelemon4327 2 жыл бұрын
Thoroughly impressed with this! You have no idea how much this helps me.
@derekgarner8524
@derekgarner8524 3 жыл бұрын
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.
@alfredsfutterkiste7534
@alfredsfutterkiste7534 2 жыл бұрын
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
@masternoble 2 жыл бұрын
Can you provide a link for reference?
@brolly414
@brolly414 Жыл бұрын
GREAT idea - thank you!
@athiiammu6814
@athiiammu6814 Жыл бұрын
@@masternoble kzfaq.info/get/bejne/a7qRjbR3yJPYZWw.html
@marksmith8021
@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.
@jamieohara4325
@jamieohara4325 4 жыл бұрын
This is a fantastic way to maximise the space of your visuals without having filters cluttering up the view! Great job!
@rosamarialopezg4167
@rosamarialopezg4167 2 жыл бұрын
Hi
@rosamarialopezg4167
@rosamarialopezg4167 2 жыл бұрын
I need to create a dashboard, could you help me pleeeease?
@ADITYA1234588
@ADITYA1234588 3 жыл бұрын
Loved it. Works perfectly 🙌 Thank you Adam!!
@hilkokriel5659
@hilkokriel5659 4 жыл бұрын
Really awesome video. Shared it with our Power BI community at work.
@goingfurther8092
@goingfurther8092 3 жыл бұрын
wow, this truly does bring my PowerBI reports to the next level! thanks for sharing!
@stephengessling7645
@stephengessling7645 4 жыл бұрын
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.
@asnelalfonsoinguanzo3295
@asnelalfonsoinguanzo3295 4 жыл бұрын
Thank you so much for sharing, it’s really interesting!
@jurgenimschoot1704
@jurgenimschoot1704 4 жыл бұрын
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
@GuyInACube 4 жыл бұрын
YES! Very true. Lots of benefits. Thanks for calling that out.
@rioaldama2487
@rioaldama2487 4 жыл бұрын
Whoa, the grouping feature is very helpful. Thanks for this!
@darylmoodley4194
@darylmoodley4194 4 жыл бұрын
Awesome, easy to follow, have put into use the grouping , slicer panel and bookmark...thanks
@GuyInACube
@GuyInACube 4 жыл бұрын
Awesome! Exciting to hear 👊
@BlakeC341
@BlakeC341 29 күн бұрын
You guys are lifesavers! Saved me from a crowded list of slicers.
@AnalyzeIt_Nael
@AnalyzeIt_Nael 4 жыл бұрын
This is a great video. Thanks for teaching us how to combine grouping and bookmark features for slicing data
@GuyInACube
@GuyInACube 4 жыл бұрын
Love it! It can definitely be used in more ways than just a slicer panel. Great option to keep in your tool belt 👊
@shatakshiagrawal3062
@shatakshiagrawal3062 3 жыл бұрын
This is soo soo good. Thank you so much for your awesome tutorials. You are my new favs in KZfaq.
@GuyInACube
@GuyInACube 3 жыл бұрын
Really appreciate that! Thanks for watching 👊
@optimistprime709
@optimistprime709 2 жыл бұрын
Thanks for this. Simple and easy to follow instructions.
@narmadabachoti8782
@narmadabachoti8782 3 жыл бұрын
I am a new subscriber, the explanation is awesome....it really helps me to gear up my Power bi reports... Thanks a lot!!!!
@nigelnoll3354
@nigelnoll3354 3 жыл бұрын
You just changed my life. That was amazing.
@sandeepadapa4848
@sandeepadapa4848 4 жыл бұрын
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
@prateeksharma-ig5qg 2 жыл бұрын
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
@arefeenshamsuzzoha3937
@arefeenshamsuzzoha3937 3 жыл бұрын
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.
@mwaltercpa
@mwaltercpa 4 жыл бұрын
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 :)
@janithrukshan
@janithrukshan 4 жыл бұрын
This is a great work guys, I was looking for this option and you've done it. Many thanks again!
@ashishshrestha7179
@ashishshrestha7179 3 жыл бұрын
Loved it.. really good way to have more space for visuals
@oseluenbaor7189
@oseluenbaor7189 2 жыл бұрын
Thank you very much for good video. Well explained and simple to follow.
@iamnishant26
@iamnishant26 2 жыл бұрын
Love what you guys do !!! This is so helpful
@pedro_ha_faria
@pedro_ha_faria 4 жыл бұрын
Great and highly relevant tip! Excellent work, guys.
@kurcel52
@kurcel52 4 жыл бұрын
Short , well explained and very valuable videos..thanks
@jaysonmagdamit4784
@jaysonmagdamit4784 Жыл бұрын
Thanks for this tutorial. Very straight forward for the bookmark tutorial.
@LuciusSullaFelix
@LuciusSullaFelix 3 жыл бұрын
Love this grouping feature. Thanks for sharing.
@jb360360
@jb360360 4 жыл бұрын
Awesome. Can’t wait to try this tomorrow. Great vid sir.
@biolaobiwole4095
@biolaobiwole4095 2 жыл бұрын
This video is awesome!! I really needed this to upgrade my report view. Thanks alot
@Kermie1967
@Kermie1967 3 жыл бұрын
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!
@basumo
@basumo 3 жыл бұрын
I'm definitely using this in my next project.. gr8 piece of work
@nupong
@nupong 2 жыл бұрын
That's awesome technique and I REALLY love this
@nikhilrao1266
@nikhilrao1266 2 жыл бұрын
Again, this is an awesome video, to the point and clear and boooooom you got a loyal subscriber.
@charlesparriet3992
@charlesparriet3992 3 жыл бұрын
Thanks for sharing... using a lot of the tools...
@mattdietert6677
@mattdietert6677 4 жыл бұрын
Thanks for updating the slicer panel tutorial! Love the customized feel you can create with it, but do the groups always have a selection box around them on mouse-over (even when published and in reading view)? I haven't been able to find a way to get rid of this highlighting and I don't always want the consumer to see the ways I have things grouped.
@SteveDPIves
@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'
@melissaphillips8506
@melissaphillips8506 2 жыл бұрын
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.
@tonyshams
@tonyshams 2 жыл бұрын
Excellent job. Thank you!
@Pa1KumarSistla
@Pa1KumarSistla 4 жыл бұрын
Awesome - Congrats on reaching and surpassing 100,000 subscribers:)...Hope you keep adding zeroes with your knowledgeable videos
@alialbayati9368
@alialbayati9368 3 жыл бұрын
Very helpful Adam 👌, thanks for sharing 👍.
@mariaa9754
@mariaa9754 Жыл бұрын
Thanks a lot! It's really helpful. Keep up the good work!
@kwaaikraai
@kwaaikraai 4 жыл бұрын
Great video! Thanks, Adam.
@AnilSharma-sg4qw
@AnilSharma-sg4qw 4 жыл бұрын
Saving lot of space in page area, many many thanks !!
@minathanh7072
@minathanh7072 2 жыл бұрын
I love this video, Im applying it to my work!
@ggamboa75
@ggamboa75 3 жыл бұрын
I am just learning power bi and you just made it a lot more interesting!!!
@rafaelparrini
@rafaelparrini 4 жыл бұрын
Simple and awesome! Thank you
@frankthetankfrombavaria
@frankthetankfrombavaria 3 жыл бұрын
Really great walkthrough! Gonna use it to build a bookmark panel
@annetteparisi1584
@annetteparisi1584 3 жыл бұрын
Really helpful video, I have referenced it multiple times!
@mauryavijai
@mauryavijai 3 жыл бұрын
Excellent video. really help to understand this new concepts.
@Slektet
@Slektet 4 жыл бұрын
Cool! Thanks for making this fun to learn :)
@jonschild2172
@jonschild2172 2 жыл бұрын
Awesome video!!! Thank you for sharing
@nathalyelias1400
@nathalyelias1400 3 жыл бұрын
Your videos are greeeeat! I have recently started to use PBI and I added this slicer panel, my boss loved it 🤭
@anthonyfernandez894
@anthonyfernandez894 3 жыл бұрын
Thank you very much Sir., kind regards from Costa Rica.
@geoffdomal5155
@geoffdomal5155 4 жыл бұрын
Nicely done, thank you. Subscribed!
@Rogi1198
@Rogi1198 3 жыл бұрын
PERFECT tutorial! Thanks!!!
@khyambaig7121
@khyambaig7121 3 жыл бұрын
Brilliant, thanks so much for the excellent video
@antoniogarrido3058
@antoniogarrido3058 2 жыл бұрын
Magic video.. lot of thanks for sharing!
@thaison7588
@thaison7588 4 жыл бұрын
Thank you a lot. I really love your videos on youtube
@harikasuryam6727
@harikasuryam6727 4 жыл бұрын
I loved this video !! Showed is soo amazing 😃
@GuyInACube
@GuyInACube 4 жыл бұрын
Love it! Thanks for watching! 👊
@natanielgi1
@natanielgi1 4 жыл бұрын
Amazing video! I will use your tips in my reports!
@Doraemon-ed3js
@Doraemon-ed3js 3 жыл бұрын
Wow! Thank you so much for this! Awesome!
@St8ofmind123456
@St8ofmind123456 2 жыл бұрын
Fantastic, perfect feature for a project portfolio dashboard
@scottsimpson2060
@scottsimpson2060 3 жыл бұрын
Brilliant, opens up the report and works like a charm, thanks
@GuyInACube
@GuyInACube 3 жыл бұрын
Love to hear that! 👊
@fredjanssen1207
@fredjanssen1207 3 жыл бұрын
Just came across your channel - videos - great stuff. Thank you!
@GuyInACube
@GuyInACube 3 жыл бұрын
Welcome to the Cube! Glad to have you aboard and appreciate the kind words. 👊
@mannykhan7752
@mannykhan7752 2 жыл бұрын
This was very helpful thank you
@karenmonken9739
@karenmonken9739 3 жыл бұрын
Super cool and helpful! Thanks!
@iamaamirkhan.
@iamaamirkhan. 3 жыл бұрын
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 😁
@wmuallstar1980
@wmuallstar1980 3 жыл бұрын
Awesome stuff. Thank you!
@barryvankessel9674
@barryvankessel9674 4 жыл бұрын
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
@GuyInACube 4 жыл бұрын
It is crazy what you can do with reports :) so many hidden gems and techniques. 👊
@rajnanannat8421
@rajnanannat8421 4 жыл бұрын
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.
@macarenazappe4485
@macarenazappe4485 2 жыл бұрын
I LOVE YOU! your content always save me from a power bi chaos!
@ivanov6083
@ivanov6083 3 жыл бұрын
Heya!!! That’s amazing! Tkx for share this!!
@driouchemountasir7894
@driouchemountasir7894 4 жыл бұрын
Excellent video as usuall. Thanks for sharing it's indeed very helpfull
@GuyInACube
@GuyInACube 4 жыл бұрын
Thanks for that! And thanks for watching 👊
@monicabozzi82
@monicabozzi82 3 жыл бұрын
Very helpful - thank you!
@pranavindi7152
@pranavindi7152 3 жыл бұрын
wow...this was simply awesome .... I can now add more visuals on my report .... thanks a ton....
@juvenciogonzalez
@juvenciogonzalez 4 жыл бұрын
NICE!! Thanks for the videos!
@abdellatifkraiem2058
@abdellatifkraiem2058 4 жыл бұрын
This is a great work guys. thnx
@FFFFFFFF316
@FFFFFFFF316 4 жыл бұрын
Thanks for sharing, this is very helpful!
@GuyInACube
@GuyInACube 4 жыл бұрын
Most welcome! Thanks for watching 👊
@michaniedospia4100
@michaniedospia4100 3 жыл бұрын
Just used the hide / unhide slicers in my report! Great channel!
Taking Buttons in Power BI Desktop to the Next Level
10:48
Guy in a Cube
Рет қаралды 399 М.
Build a Slicer Panel in Power BI (2022/2023)
10:32
Guy in a Cube
Рет қаралды 205 М.
What it feels like cleaning up after a toddler.
00:40
Daniel LaBelle
Рет қаралды 41 МЛН
Mom's Unique Approach to Teaching Kids Hygiene #shorts
00:16
Fabiosa Stories
Рет қаралды 6 МЛН
Best KFC Homemade For My Son #cooking #shorts
00:58
BANKII
Рет қаралды 50 МЛН
Handling MULTIPLE fact tables in Power BI
9:02
Guy in a Cube
Рет қаралды 300 М.
2 ways to reduce your Power BI dataset size and speed up refresh
17:24
NEXT LEVEL Conditional Drill in Power BI Desktop with buttons
13:13
Guy in a Cube
Рет қаралды 155 М.
5 IDEAS to take Power BI reports to the NEXT LEVEL
9:49
Guy in a Cube
Рет қаралды 263 М.
Build a Slicer Panel in Power BI Like a PRO
20:40
Your Own KPI
Рет қаралды 57 М.
STOP publishing your Power BI report until you do these 5 things!
10:15
Build a TOGGLE BUTTON Like a PRO in Power BI
14:06
How to Power BI
Рет қаралды 177 М.
Samsung laughing on iPhone #techbyakram
0:12
Tech by Akram
Рет қаралды 635 М.
КРУТОЙ ТЕЛЕФОН
0:16
KINO KAIF
Рет қаралды 6 МЛН
Top 50 Amazon Prime Day 2024 Deals 🤑 (Updated Hourly!!)
12:37
The Deal Guy
Рет қаралды 1,4 МЛН
Самые крутые школьные гаджеты
0:49