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
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
Bas - I watch all of your videos and they are always very helpful. Please keep up the good work!!
@HowtoPowerBI
Жыл бұрын
Thanks, will do! 😀
Love the editing ❤
It has always been annoying not being able to clear slicers with a single click. I will apply this on my dashboards. Thanks Bas.
You are an excellent power bi developer
Love your content, many thanks from India!
@HowtoPowerBI
Жыл бұрын
So nice of you thanks! 🙏❤️
Your are the best, thx!!!
BAS is the game changer, thank you for sharing
Bas, great video as always..👍
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?
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
Жыл бұрын
You know on Power BI Service there is a button reset slicers&filters ?
@OscarSouto
Жыл бұрын
@@sebastien_1237 Yes, I know, I was referring to a public Power BI on the web. Thanks anyway.
@steponaszonys8385
2 ай бұрын
Exactly, the same issue.
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.
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.
Bas always come with some good content. 🙂
@HowtoPowerBI
Жыл бұрын
Thx!🎉
Great Content as always! do you happen to have a video on that visual that shows the applied filters?
@HowtoPowerBI
Жыл бұрын
kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
You are amazing Bas..I love your Videos❤️
@HowtoPowerBI
Жыл бұрын
Glad you like them!
Bas, Hope that Power BI team is watching your videos.
How can I do that top filter box? That shows the filter selected options? That thing is amazing!
You are genius 👌
@sayyadabdulmugani8829
Жыл бұрын
Are you MVP or MCT? (Microsoft Valuable Person)?😊
Thanks for sharing, another great tutorial and well explained. What UNICODE you use for world and computer icon?
@erickung4302
4 ай бұрын
Emoji. Win + . open emoji panel and add emojis to your field name.
Believe I'm the first viewer here!! Perks of keeping all notifications on😎😂
@HowtoPowerBI
Жыл бұрын
Haha awesome thx for watching!
Thanks BAS Great Video Can we Create Navigation Panel With Slicer Panel in The Same Report
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
Жыл бұрын
Great point Jack! Hope that it will get updated on future PBI versions.
@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.
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.
Takk!
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
Thanks for the video, Bas. Any Idea how we can set the New proporties within a theme?
@HowtoPowerBI
Жыл бұрын
Didnt try myself yet.. saw a few posts flying by on this topic though
Need more designs to learn.
@HowtoPowerBI
Жыл бұрын
Then stick around :)
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.
How did you create that filter panel above.. That shows all Applied filters?? Nice video 😊😊
@HowtoPowerBI
Жыл бұрын
thanks! explanation is in this video kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
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
Can you explain how you created that square named filter to show which filters are applied?
@HowtoPowerBI
Жыл бұрын
see video here kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
@truptidahiphale7586
Жыл бұрын
@@HowtoPowerBI Thanks....your videos are very helpful to me and one of the reasons to love Power BI....Appreciate it...🙏
How can i create the first pannel that shows the filter applied?
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?
How can i do the filter list and interaction like the top of your video
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
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
Жыл бұрын
May I know the link to the video you watched? Edit: I saw it here ➡ kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
@juanignacioXI
Жыл бұрын
@@NicaPascual29 Of Course Nica, is this one: kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
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.
Is there a workaround to incorporate the clear all slicers button for slicers that are hidden away in a bookmark?
@HowtoPowerBI
Жыл бұрын
nope, then you would need to do it the old way with bookmarks
How we can creat beatiful filter table on the bove?
@HowtoPowerBI
Жыл бұрын
see video here kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
Why cut the powerbi tools? Just show the entire screen. Nice Video.
@HowtoPowerBI
Жыл бұрын
😊 thx , i like it like this
How to change color on clear all slicer, when something selected on slicer change into red when all are clered then green
@HowtoPowerBI
Жыл бұрын
Its only possilbe for now with extra shapes.. explanation is in this vid kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
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
Жыл бұрын
kzread.info/dash/bejne/g5WDqZZrmcaYp6w.html
Hi Bas, how can I implement These filter categories? I guess, there is an easy solution. Thanks in advance.
@HowtoPowerBI
2 ай бұрын
Sorry not sure what you r asking
@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
2 ай бұрын
Yes with boomarks
Can I get the pbix file
@HowtoPowerBI
Жыл бұрын
Link is in the description
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
Жыл бұрын
just put them next to each other then, no ?
More and More starting to look like Qlikview and its Current Selections Box. Like you though I hope they continue to do more.
@HowtoPowerBI
Жыл бұрын
I guess you dont think that s a good thing :p ?
@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.
Would you actually call it Slicer design 2.0?.... That will come soon too, the title is too clickbaity for my taste.
@HowtoPowerBI
Жыл бұрын
Wait for the video slicer design 3.0 😂
@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 😅