SLICER DESIGN 2.0 in Power BI I UPGRADED functionality and UX

Ғылым және технология

In this video I show you how to use the new slicer buttons in Power BI and how to improve the design and user experience of a slicer panel.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:59 Reset slicers - the old way
04:05 Reset slicers - the new way
06:17 Apply all slicers
08:48 Redesign of the slicer panel
11:32 Toggle between instant and apply all slicer selections
16:03 Upgrade design of the slicer state toggle
18:47 Why you need the apply all slicers button
20:48 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZread: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Пікірлер: 82

  • @CavanHaganInvesting
    @CavanHaganInvesting Жыл бұрын

    That apply button is a game changer. Was super frustrating that the report refreshed every time a change was made when the user had 5-10 selections to make to get to their desired result

  • @liquidsilver641
    @liquidsilver641 Жыл бұрын

    Bas - I watch all of your videos and they are always very helpful. Please keep up the good work!!

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thanks, will do! 😀

  • @muttch
    @muttch Жыл бұрын

    Love the editing ❤

  • @TheBkDani
    @TheBkDani Жыл бұрын

    It has always been annoying not being able to clear slicers with a single click. I will apply this on my dashboards. Thanks Bas.

  • @dramaticreviews6278
    @dramaticreviews6278 Жыл бұрын

    You are an excellent power bi developer

  • @vinays148
    @vinays148 Жыл бұрын

    Love your content, many thanks from India!

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    So nice of you thanks! 🙏❤️

  • @Gabri3l756
    @Gabri3l756 Жыл бұрын

    Your are the best, thx!!!

  • @unnikrishnansanthosh
    @unnikrishnansanthosh Жыл бұрын

    BAS is the game changer, thank you for sharing

  • @sanumpzha
    @sanumpzha Жыл бұрын

    Bas, great video as always..👍

  • @jimcesarloyolasantamaria5757
    @jimcesarloyolasantamaria5757 Жыл бұрын

    Great Video as always Bas, I have a question, what is the behavior when you use the Apply slicer but you are using cascade mode in the slicer? for instance if I have a category slicer and a product slicer if I'm using the apply slicer will never filter each other, right?

  • @OscarSouto
    @OscarSouto Жыл бұрын

    You are the best explaining Power BI, thank you very much !! Related to "Reset slicers", of course is a good improvement, but not perfect, as it only clears the slicers (I know, is in the name) but it doesn't reset the user selections made in the visuals and you know a dashboard is usually full interactive (or even you can use a visual as a filter as you showed us many times). I would like a button that reset every filter to set the page at the initial state. I'm afraid I still need to use bookmarks. Just to warn you. Thank you for your videos !!!

  • @sebastien_1237

    @sebastien_1237

    Жыл бұрын

    You know on Power BI Service there is a button reset slicers&filters ?

  • @OscarSouto

    @OscarSouto

    Жыл бұрын

    @@sebastien_1237 Yes, I know, I was referring to a public Power BI on the web. Thanks anyway.

  • @steponaszonys8385

    @steponaszonys8385

    2 ай бұрын

    Exactly, the same issue.

  • @philipedesouzasantos1201
    @philipedesouzasantos1201 Жыл бұрын

    Hello friend! Thanks for this super tip! I really loved it. Just a note: I've just downloaded your pbi project and I noticed that the "Auto refresh" buttom (which you used the thunder icon) is not working, just the manual method is updating the main visual.

  • @scobob
    @scobob Жыл бұрын

    As much as I love Power BI for it's modeling and speed, the visuals and interface are lagging behind the competitors. The functionality you displayed here was inherent in Qlik 7 years ago. I was able to create beautiful interfaces that were highly configurable and conditional right out of the box. Simple things like conditionally showing a visual was and is standard in Qlik while it's still not possible today in Power BI. I don't understand why the visuals in Power BI are so parochial.

  • @narendrababu2287
    @narendrababu2287 Жыл бұрын

    Bas always come with some good content. 🙂

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Thx!🎉

  • @ianalvarez7953
    @ianalvarez7953 Жыл бұрын

    Great Content as always! do you happen to have a video on that visual that shows the applied filters?

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @scandinavia_adventure
    @scandinavia_adventure Жыл бұрын

    You are amazing Bas..I love your Videos❤️

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Glad you like them!

  • @piotrkuc8936
    @piotrkuc8936 Жыл бұрын

    Bas, Hope that Power BI team is watching your videos.

  • @jacson5950
    @jacson5950 Жыл бұрын

    How can I do that top filter box? That shows the filter selected options? That thing is amazing!

  • @sayyadabdulmugani8829
    @sayyadabdulmugani8829 Жыл бұрын

    You are genius 👌

  • @sayyadabdulmugani8829

    @sayyadabdulmugani8829

    Жыл бұрын

    Are you MVP or MCT? (Microsoft Valuable Person)?😊

  • @santiagocancelacodina9968
    @santiagocancelacodina9968 Жыл бұрын

    Thanks for sharing, another great tutorial and well explained. What UNICODE you use for world and computer icon?

  • @erickung4302

    @erickung4302

    4 ай бұрын

    Emoji. Win + . open emoji panel and add emojis to your field name.

  • @kumarabhijeet8968
    @kumarabhijeet8968 Жыл бұрын

    Believe I'm the first viewer here!! Perks of keeping all notifications on😎😂

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Haha awesome thx for watching!

  • @mohammedmanna3488
    @mohammedmanna3488 Жыл бұрын

    Thanks BAS Great Video Can we Create Navigation Panel With Slicer Panel in The Same Report

  • @jackstrudley1039
    @jackstrudley1039 Жыл бұрын

    Great video as always. The main problem with the apply all is the other slicers don't update. For example, if I select a Product Category, the Product slicer isn't updated with only the Products within that Category making the user experience poor.

  • @JustRandomExplorer

    @JustRandomExplorer

    Жыл бұрын

    Great point Jack! Hope that it will get updated on future PBI versions.

  • @ShaloVBT

    @ShaloVBT

    Жыл бұрын

    Maybe a possible solution is to keep both slicers visible in both bookmarks state, but overlap them in different orders. I haven't tried it yet though.

  • @alexandermilland6674
    @alexandermilland667410 ай бұрын

    Is there a quick way to copy paste this between report pages or even reports? Feels like there is a lot of setting up with bookmarks and button interactions for all of it.

  • @geirberge8971
    @geirberge8971 Жыл бұрын

    Takk!

  • @Daithi354
    @Daithi354 Жыл бұрын

    That panel showing the filtered values, how did you do that and will it show all values if a user selects multiple values in a single slicer? Can't find the video where you did that. Edit: Nvm, saw that you linked it in a reply below, much appreciated

  • @jelledaems808
    @jelledaems808 Жыл бұрын

    Thanks for the video, Bas. Any Idea how we can set the New proporties within a theme?

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Didnt try myself yet.. saw a few posts flying by on this topic though

  • @Radhakrishna-sm4td
    @Radhakrishna-sm4td Жыл бұрын

    Need more designs to learn.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Then stick around :)

  • @Drengen10
    @Drengen1010 ай бұрын

    Hi. I made my own version of this, but on a folded out panel using bookmarks to fold it out . My main issue is when i fold it out then 1) The display of the filters (product vs location) isn't how it was left off as - the visual part of it. But the slicer/bookmark selecter for those two is how it was left off as. This causing some inconsistencies. 2) Same issues applies to the quick filter vs apply filter button and the bookmarks behind it. I wonder if there is a way to work around this? Aka make a fully functional version of your above, but from a filter panel that opens up / hides instead of always being on the page.

  • @krishnakishorepeddisetti4387
    @krishnakishorepeddisetti4387 Жыл бұрын

    How did you create that filter panel above.. That shows all Applied filters?? Nice video 😊😊

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    thanks! explanation is in this video kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @wweghorst
    @wweghorst Жыл бұрын

    Hoi Bas, de lamp reflectie in de wand achter je leidt nogal af, zou fijn zijn als je daar iets aan zou kunnen doen. Alvast bedankt

  • @truptidahiphale7586
    @truptidahiphale7586 Жыл бұрын

    Can you explain how you created that square named filter to show which filters are applied?

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    see video here kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @truptidahiphale7586

    @truptidahiphale7586

    Жыл бұрын

    @@HowtoPowerBI Thanks....your videos are very helpful to me and one of the reasons to love Power BI....Appreciate it...🙏

  • @yousefesfahanian2636
    @yousefesfahanian26365 ай бұрын

    How can i create the first pannel that shows the filter applied?

  • @aastharatnawat3033
    @aastharatnawat30338 ай бұрын

    Hi, How can I use "Filter by list by devscope" visual to exclude a list of values from my report. Generally if we select a value from slicers or filters the report show only the values we have selected but I want the opposite. How can I do that?

  • @sukanneeklangniam5222
    @sukanneeklangniam52227 ай бұрын

    How can i do the filter list and interaction like the top of your video

  • @shreyassrikanth5017
    @shreyassrikanth5017 Жыл бұрын

    Could you make a video to show how to make a slicer which searches text across multiple columns or some required columns. Eg search location New York or just a search if category like phone . Instead of having two slicers or using bookmarks

  • @juanignacioXI
    @juanignacioXI Жыл бұрын

    Hello Bas, please can u show us how you make that list of slicers that are been apllied? Edit: Video found hahaha, thanks you a lot Bas you are the best of the bests!

  • @NicaPascual29

    @NicaPascual29

    Жыл бұрын

    May I know the link to the video you watched? Edit: I saw it here ➡ kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @juanignacioXI

    @juanignacioXI

    Жыл бұрын

    @@NicaPascual29 Of Course Nica, is this one: kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @satyanarayana-by5wf
    @satyanarayana-by5wf7 ай бұрын

    It seems had issue with Apply all button when second slicers filters based on first slicer . How to resolve this issue? Example sub category filters based in category filter will not effect until click on Apply button.

  • @ClutchNrb
    @ClutchNrb Жыл бұрын

    Is there a workaround to incorporate the clear all slicers button for slicers that are hidden away in a bookmark?

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    nope, then you would need to do it the old way with bookmarks

  • @nhantruongvan4840
    @nhantruongvan4840 Жыл бұрын

    How we can creat beatiful filter table on the bove?

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    see video here kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @gabiru-danger
    @gabiru-danger Жыл бұрын

    Why cut the powerbi tools? Just show the entire screen. Nice Video.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    😊 thx , i like it like this

  • @zorankrekic3006
    @zorankrekic3006 Жыл бұрын

    How to change color on clear all slicer, when something selected on slicer change into red when all are clered then green

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Its only possilbe for now with extra shapes.. explanation is in this vid kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @bvbull200
    @bvbull200 Жыл бұрын

    Where is the video for how to create that list of applied filters? I use that in Qlik and have never found a PBI equivalent. That would be huge for me.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html

  • @dannyockenfuss1275
    @dannyockenfuss12752 ай бұрын

    Hi Bas, how can I implement These filter categories? I guess, there is an easy solution. Thanks in advance.

  • @HowtoPowerBI

    @HowtoPowerBI

    2 ай бұрын

    Sorry not sure what you r asking

  • @dannyockenfuss1275

    @dannyockenfuss1275

    2 ай бұрын

    Sorry, Bas. I didn't express myself well. In the example, you can switch back and forth between product slicers and location slicers. Is this implemented with bookmarks?

  • @HowtoPowerBI

    @HowtoPowerBI

    2 ай бұрын

    Yes with boomarks

  • @gagansingh3481
    @gagansingh3481 Жыл бұрын

    Can I get the pbix file

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Link is in the description

  • @brightonalbert3237
    @brightonalbert3237 Жыл бұрын

    Thank you, i have a team of collogues who dislike the bookmarks and are only interested in seeing all one view i have 7 slicers how can you help me

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    just put them next to each other then, no ?

  • @mcnater
    @mcnater Жыл бұрын

    More and More starting to look like Qlikview and its Current Selections Box. Like you though I hope they continue to do more.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    I guess you dont think that s a good thing :p ?

  • @mcnater

    @mcnater

    Жыл бұрын

    @@HowtoPowerBI No it's fine...I just find it funny how they are coalescing into similar ways to make selections. Its interesting to me that Qlikview had this sort of thing over 10 years ago and it's still better implemented than PBI. I just feel PBI needs to step up their game faster.

  • @In_a_state
    @In_a_state Жыл бұрын

    Would you actually call it Slicer design 2.0?.... That will come soon too, the title is too clickbaity for my taste.

  • @HowtoPowerBI

    @HowtoPowerBI

    Жыл бұрын

    Wait for the video slicer design 3.0 😂

  • @stugryffin3619

    @stugryffin3619

    Жыл бұрын

    I'm very very sensitive to click bait titles. I despise them. But this is not that. This is an update to Baz's first slicer video, so Slicer 2.0 is correct. That said, Baz I don't think that background is working for you. It looks like you're filming where you had a small fire in your bathroom 😅

Келесі