No video
The ULTIMATE Slicer Panel in Power BI
Рет қаралды 198,927
Күн бұрынIn this video I walk you through how I would build the ultimate slicer panel. I show you how to integrate a bookmark navigator to deal with a large number of slicers and to bring structure. Then I have a closer look at how to visualise the applied filters and how we can highlight the slicers that have a filter in place.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.i...
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatrainin...
Power BI Essentials datatraining.i...
Business User Training datatraining.i...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:23 Formatting and organising the slicer panel
04:00 Using the bookmark navigator to deal with many slicers
07:52 Showing which filters are applied - Option 1
13:10 Showing which filters are applied - Option 2
18:43 Adding a reset filters button
21:28 Improving the design
30:12 Creating an indicator for slicers with an applied filter
35:56 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.ne...
Newsletter datatraining.i...
---------------------------------
👇 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.epidemicso...
🚀 For growing on KZfaq: www.tubebuddy....
🏄 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
@HowtoPowerBI Жыл бұрын
If you are interested in taking your Power BI Design Skills to the Next Level check out my 4 weeks program: my.datatraining.io/pages/powerbidesigntransformation
@sukoi2113 Жыл бұрын
This is so much fun and next level thing. You are the "Bear Grylls" of Power BI, the way you consume every possible features in it. I bet not even the developer team behind ever thought of these tricks.
@HowtoPowerBI Жыл бұрын
Thanks Rajneesh :) this means a lot, very happy that you think its good 😊
@meghanamags9217 Жыл бұрын
I agree with you Raj
@kostaszogo21 Жыл бұрын
This guy deserves more subscribers than Netflix and Disney+ combined... Great video Bas, continue spreading that wisdom!
@HowtoPowerBI Жыл бұрын
Ohh :) this made my day thanks a lot!
@shamf6624 Жыл бұрын
so true. i am amazed
@RichardOliver Жыл бұрын
I love the way you acknowledge the (current) product shortcomings but find a way to work round it. Very creative!
@HowtoPowerBI Жыл бұрын
Hey Richard, thanks a lot for this feedback, really appreciate it!
@peterg4130 Жыл бұрын
Love the solution to identify which filters are applied. That is such a clutch feature when you have a filter panel that is not visible by default. I was playing around with Option 2 a little bit, and I decided to go with something like this ShowFilters3 = "Filters (" & IF ( ISFILTERED('Data'[Region]), 1, 0) + IF ( ISFILTERED('Data'[Property Type]), 1, 0 ) & ")" If space is an issue, then dropping this measure as "Text" in a Button shows the user how many filters are applied, and they can click the button to show the Filter panel and make any changes.
@karthikprabhakar2888 Жыл бұрын
Just falling in love with all the manipulations and how ur fooling with the functionalities to bring the BEST of the BEST, just amazing, Brilliant! 💓💓💓💓💓
@pawepilch2435 Жыл бұрын
This is so helpful. I spent a couple of hours this week looking for a solution for many slicers and I still didn't have clear idea how to do that. And today you are coming up with this solution. Thank you so much 👌
@HowtoPowerBI Жыл бұрын
Hi Pawel! That’s awesome! Super happy to hear it was helpful 😎 powodzenia! ;)
@hi55us2 Жыл бұрын
Bas continues to produce the absolute best Power BI content, just can't get enough from it and I thought I knew what I was doing. Keep up the great work!
@HowtoPowerBI Жыл бұрын
Thanks a lot, really appreciate it! 😎
@dsswooshy 4 ай бұрын
Brilliant video thanks. My company uses Qlik and Power BI and well, let's just say as the Power BI developer, being able to develop the filter pane in Power BI is nice.
@prabz4322 Жыл бұрын
This is great stuff Bas. Your style of explaining things is so easy for anyone to understand. 👍👍👍
@HowtoPowerBI Жыл бұрын
🙏 thanks totally my aim: making Power BI easy and fun :)
@ajdiwbtodUyt Жыл бұрын
@@HowtoPowerBI Mission accomplished!!!
@coreyayers3623 5 ай бұрын
Really Really well done! I am bingeing your videos! Love the easy to understand directions and your focus on things looking nice! Well done keep them coming!
@kayvonsadrabadi9555 Жыл бұрын
Thoroughly enjoy your knowledge and enthusiasm. Thank you for what you do! 🙏
@HowtoPowerBI Жыл бұрын
:):) thank you very much!
@Vittoria222 Жыл бұрын
I watched the video and immediately implemented the idea in my Power BI report! Thank you!
@stutisinghal1514 4 ай бұрын
So much to learn just from one video
@EduardoCortezOrtega Жыл бұрын
The world needs more content creators like you, thanks!
@shubhamkumarsinha5224 6 ай бұрын
You made me in love with PBI Dashboard....Just amazing !!!!
@sarveshdeshpande1772 Жыл бұрын
This is awesome ........... your ideas are next level , I am improving day by day watching your videos' in terms of formatting. Kudos for all your hard work dude !!!!
@HowtoPowerBI Жыл бұрын
Very happy to hear this sarvesh! Thanks a lot!
@paulgallagher2987 Жыл бұрын
Thanks as Ever Bas! I've only used the Dax Studio DumpFilters feature for de-bugging before as I found it too cumbersome to use in a report. However I hadn't thought of editing the text and only using the sections I needed to make it production friendly before! This is a great addiiton to my filter panel. I also love how you purposely make common mistakes to re-inforce our learning. Like you did with the 'Data' Bookmark Setting. 👍👍👍
@andreicostin3 Жыл бұрын
U`re awesome with these quality videos that u`re still making weekly , love you job and Power Bi skills :D
@carolpruett9208 Жыл бұрын
I am looking forward to using Bas' ideas in my slicer panels. This is definitely how to make your slicer panels look sleek while using the space on your report page more efficiently.
@YeshuKaChela Жыл бұрын
Super underrated channel. Really love your videos
@HowtoPowerBI Жыл бұрын
Thanks Angad:)
@juliemillerwealthartificer4764 Жыл бұрын
FANTASTIC!!!! Thank you so much!!! I will definitely use this method going forward.
@innocentigiwa5509 Жыл бұрын
What inspires you? because these innovations are truly extraordinary
@jimwilder7828 4 ай бұрын
Awesome! Keep up the good work!
@crystalcarpenter8310 4 ай бұрын
Thank you. I'm just learning. I would love to know how to add columns and new calculations like how long something was there in days.
@hi_vishy Жыл бұрын
Definitely deserve many more likes and subscribers.
@ozansen_ozibaba Жыл бұрын
This is really high quality video about both design and filter context! As always, Good Job, Dear Bas!
@why-bi Жыл бұрын
It is amazing how much work you spend for one video. Great video and excellent inputs.
@HowtoPowerBI Жыл бұрын
Right, takes a long time :) but worth it :)
@ahmetsuna3216 Жыл бұрын
Thank you for your effort, your work provides convenience in our business life, you are appreciated 👍👍👌👌
@HowtoPowerBI Жыл бұрын
Thanks Ahmet! Good to hear you think so!
@FarhanKhan-lp3ds Жыл бұрын
Everything is so well thought out!
@HowtoPowerBI Жыл бұрын
:) appreciate it Farhan
@sebastianbaenaaristizabal6176 Жыл бұрын
I really enjoy all your videos, thanks for share your knowledge, greetings from Colombia!
@HowtoPowerBI Жыл бұрын
Thanks Sebastian :) all the best from the Dutch guy in Germany
@kees1058 2 ай бұрын
Dag Bas, ik kijk met veel plezier naar je video's. Wat ben jij altijd vrolijk, zeg 😄Weet je ook hoe ik ervoor kan zorgen dat lege rijen worden verwijderd ondanks dat de datum in de eerste kolom staat? Ik wil de weekenden buiten de berekening van het gemiddelde houden.
@vishalnasre1251 Жыл бұрын
OMG! This is mind-blowing Bas. Thanks for sharing :)
@HowtoPowerBI Жыл бұрын
Glad you think so Vishal! 😎
@kukeleku13 Жыл бұрын
Great video! You make it look so easy but it's a really clever solution. Thanks for sharing!
@paulpriest7988 Жыл бұрын
Your approaches are brilliant! Thank you for your work.
@HowtoPowerBI Жыл бұрын
thanks Paul for the kind words!
@user-pe9we1qm9e Жыл бұрын
You are the best teacher 💫
@LuisBOrtiz-bt8fn Жыл бұрын
You are great men! Every video is so fun and useful!
@HowtoPowerBI Жыл бұрын
😎 thanks :):) super happy it is useful for you
@ralphap2163 Жыл бұрын
Amazing How to video! Really helped me out clean up my dashboard which contained too much bookmarks... Does unicode table site work? Can't seem to find it.... It's the last bit of the puzzle to ease down all the text
@JamesBatchelorGoogleProfile Жыл бұрын
Nice! I'm always looking for better ways to deal with this. I'll be glad when either visibility or layer can be set in DAX. No reason to build bookmarks simply to show hide objects. Let me say on off or +1/-1 in layers.
@christiangarza3965 Жыл бұрын
This is really amazing! I'm definitely using this on mi job. Thanks mate
@jonjon8422 Жыл бұрын
You Sir are just something else. I am mega impressed. As others said it - this is next level
@HowtoPowerBI Жыл бұрын
Ah thank you so much for these kind words!
@jamesabbott3052 10 ай бұрын
Thanks! I learned quite a bit from this video.
@HowtoPowerBI 9 ай бұрын
Glad to hear it James, thanks for your support:)
@ceciliaaponte1107 8 ай бұрын
As an idea, I love the videos and would be very useful to have the part where you show up explaining to be a smaller. I watch the videos at work and some collegues might think I am watching youtube for other things since you are showing up in most of the screen. Making it smaller would be better to not give others a bad impression. Thanks!!
@HowtoPowerBI 8 ай бұрын
thx for the feedback :) sticking with this format though
@smkotian Жыл бұрын
This is really amazing Bas. Super helpful. Exactly what I need at the moment😆 .. you seem to read my mind a lot these days 😄😄😄 .. Thank you so much for sharing this.
@HowtoPowerBI Жыл бұрын
You are welcome! Ah thats the voice i hear in my head then ;)
@anthonymichellier6805 Жыл бұрын
Wow ! What a masterclass on this topic Bas, thanks a lot 🙏
@ahmedalkherbi Жыл бұрын
Awesome! I learned lots of things. Thank you very much.
@komanguy Жыл бұрын
Awesome! I learned lots of things today. Thank you very much.
@HowtoPowerBI Жыл бұрын
nice!!! happy to hear that 😎 thx for watching
@aapeebles Жыл бұрын
This was really helpful! Thank you.
@NeoKnight9 Жыл бұрын
Do you need to close brackets for RGBA at 31:44 ?
@dp6736 9 ай бұрын
Amazing tips. Thank you very much.
@reinaldodelmirocostafilho817 Жыл бұрын
MUITO OBRIGADO por compartilhar seus conhecimentos. Voce tem muitos fãs aqui no Brasil. Venha ao Rio de Janeiro nos ensinar presencialmente. Será super bem vindo! Aprendo bastante e sempre aplico nos dashs que crio. Fraterno abraco,
@normandass6053 Жыл бұрын
Fantastic Mate, excited to watch these amazing tricks Much appreciate your sharing :)
@HowtoPowerBI Жыл бұрын
Thanks Norman :)
@robinengblom2271 Жыл бұрын
You sir, just earned a new sub! Your content is so good!
@HowtoPowerBI Жыл бұрын
yey - thanks for the Sub!😊
@abdulrehman56 Жыл бұрын
Great material ...... lots of appreciation
@HowtoPowerBI Жыл бұрын
Thank you Abdul! ☺
@AlesKus 10 ай бұрын
Love those infos!
@TechnoSol-h9j 15 күн бұрын
Thank you very much
@Tyraelxadrias Жыл бұрын
Nice Hair Cut Bas! Thanks for the video :)
@HowtoPowerBI Жыл бұрын
Oh wow thx for noticing :)
@stefancui3093 Жыл бұрын
The select all option will disappear after you search in a slicer, do you know anyway to fix this?
@bigspooon2317 Жыл бұрын
thank you Boss😊 I can Ultimate slicer! very good 🎉
@bessa0 Жыл бұрын
The best channel! Thank you.
@HowtoPowerBI Жыл бұрын
Thank you sooo much :)
@narasimhavenumuddala6669 Жыл бұрын
Great Video on Slicer's and very useful in Real time. Please let me know if you've any course on Data Science
@rissato4739 Жыл бұрын
Como sempre, só material top! Obrigado por compartilhar com a gente!
@HowtoPowerBI Жыл бұрын
Thanks a lot Rodolfo
@Crysteps 3 ай бұрын
Bas, thank you so much for what you do. I have learned so much about PBI design from you. is your camera background a greenscreen ?
@HowtoPowerBI 3 ай бұрын
😃 awesome, great to hear that! Nope, no green screen
@leleca Жыл бұрын
What if there's all visual filters applied and it appears on your "ShowFilters" and you don't want to? Great video, btw! Thanks for sharing.
@MladenDJoleJevtic Жыл бұрын
Love the insights and creativity you provide! Thank you very much, you're a great inspiration! One question though: with all the objects in the report just for the slicers (including the DAX behind it which is filtering over tables), when it comes to a larger data model, are there any performance differences - from the initial load to the response time on other visualizations in the page? That's the question it comes to mind as soon as i see multiple objects in the report.
@Lotaristo Жыл бұрын
I wanted to ask the same question, maybe Bas should even make a video with explaining of possible performance issues.
@scramiro1 Жыл бұрын
What if you have so many more filters? Can you put them in a visual that allows scrolling down all those? Couldn't find anything on KZfaq. Thanks
@down_with_data Жыл бұрын
Amazing video, do I need to create the bookmarks for each page? If I copy and Pasten in another page is not working anymore
@user-vo2pw3xx4q 8 ай бұрын
very very useful, but for other pages I must create all the slicers panel one more time?
@dcpowered Жыл бұрын
Amazing! Thank you so much, Bas!
@HowtoPowerBI Жыл бұрын
Thnis Shakeel! :):)
@anwaarkhalil868 Жыл бұрын
Great Video as usual
@jessicac9596 10 ай бұрын
Fantastic!😲
@unnikrishnansanthosh Жыл бұрын
Fantastic BAS, this is wonderful
@HowtoPowerBI Жыл бұрын
Thanks Santhosh! Much appreciated
@Wzxxx Жыл бұрын
U r awesome man!
@WilliamPete Жыл бұрын
What is the link to the Unicode tables referenced at 25.49 ? I
@nseworld5521 Жыл бұрын
Thy, Bass! Great idea with headers
@HowtoPowerBI Жыл бұрын
Thanks :):)
@Mister_JB_yep Ай бұрын
Dank je, Bas
@rlds07 Жыл бұрын
Simply the best with amazing tips.
@HowtoPowerBI Жыл бұрын
:) thanks Rafael!
@labiancami Жыл бұрын
Does the implementation of all this design affect the performance of the file?
@HowtoPowerBI Жыл бұрын
Definitely every bookmark and shape has impact on the performance
@msachinkumar9886 Жыл бұрын
Ultimate ... Awsome
@sandeepamaravadi Жыл бұрын
Hey. I think if we use so many shapes for formatting purpose, this may slow down the entire report. If we create all those background shapes in Power point and save it as image and then import that in Power BI, it will reduce lots of visuals. In that way, we will still have all the lovely look and feel and performance will also be improved.
@HowtoPowerBI Жыл бұрын
Definitely
@kassiowifried Жыл бұрын
Good Job, Thank you Very Very much
@jaleszek Жыл бұрын
BRILIANT!!!
@hindyal_masaeed4480 10 ай бұрын
if you could give us the download link for this templet it would be great :)
@sevlasiul1 3 ай бұрын
Hi! @HowtoPowerBI @all My initial shape just appears solid over the slicers, and not translucent like in you example. Do you have any clue why? Thanks if you can!
@SandervanderVelden-ll4wq Жыл бұрын
What a great feature in a business who needs a lot of filters! The only problem I am struggling with is how I can use this over multiple tabs? I need the same filters in other tabs as well. Do I need to construct the bookmarks in every new tab? That is now my solution, or can it be done with the options 'Data', 'Display', ''Current visual', etc? And is it correct that if I do clear filters, I still stay in the selected filters (like 'Location')?
@weronikajakubowska2976 5 ай бұрын
I have a chart with data. There is a slicer for the chart that filters data by date. Can I create a single-selection filter that will automatically be set to the most recent date?
@patrimoinealgerienetberber282 Жыл бұрын
Thank you Baas
@leenbemindt4504 Жыл бұрын
Great video! I like your style :-) I created an amazing slicer panel with your tips, but copying this one to all my other pages in the report seems not so easy:-( Any tips on that?
@k.pratibhareddy8233 Жыл бұрын
Thank you for the Video. Has been really helpful. But a quick question, I have created the slicer panel as you have created in the video, but the bookmarks don't work as I have created the same slicer panel for multiple pages. It would really nice, if you could give a solution. Thanks!
@josefedericopresno6668 Жыл бұрын
Eres un genio, Bas!
@emilyamalkin4367 Жыл бұрын
Thank you!
@COMMANDERFOX31 Жыл бұрын
I am new to Power BI, I did not know you can code in this environment. This DAX language reminds me a lot of VBA, which I am used to, so DAX or M shouldn't be difficult to learn, right? Either way, thanks for the great tutorial Bas!
@HowtoPowerBI Жыл бұрын
Quite sure you will pick it up quickly! All the best
@sandeepchauhan7742 Жыл бұрын
Hi, when we click on shape which is under slicers, the slicers go away and we need to press esc key in keyboard to get the slicers back. What is the solution to stop this behaviour? Pls reply. Thanks in advance.
@mcnater Жыл бұрын
Great and thorough walk through. Still annoys me to no end Microsoft doesn’t make this stuff more built in. What are they doing?
@HowtoPowerBI Жыл бұрын
Guess they are working on other stuff… :)
@jenniferdustin8214 9 ай бұрын
What would you need to change in the measures to get the filter table to work with a hierarchy based slicer?
@nidhyyo_O Жыл бұрын
Hi Bas, Thank you for the wonderful tips in the custom slicer contents, it is surely helping me in the report designing, But I did has a doubt regarding this, If I am using a text filter to filter my data will I be able to just show the text as the filter in the Filter Header section?
@vanessamondillon6484 Жыл бұрын
Hi, I tried to used with hidden page … but is not ok … when I go in hidden page with shortcut button the bookmark is reset, you have solution to used with button and hidden page ?
@meghanamags9217 Жыл бұрын
Hi Mr. Bas, I need one concern how to attend the workshop or courses online PBI pls let me know, Thank you, need help in my project technical way
@saulkattan6394 Жыл бұрын
Great video!!! I am trying to get the Clear Filter button background to change color when filters are applied to indicate that is “active”. Have a measure that checks if filters are applied for each of the slicers and if so returns “yellow” if not returns gray. When I try to apply it as conditional formatting it does not allow me to select that measure. Any idea how to accomplish this? Keep up the great work!!!
@allwindsilva1883 Жыл бұрын
if i do not use all the slicers then the second option does not show the header titles. Looks like they have to be selected in the order of the Show filter header DAX i.e class name , color name , product subcategory name and so on. if i do not chose color name and filter header names do not show up
How to Power BI
Рет қаралды 136 М.
Jason Derulo
Рет қаралды 32 МЛН
Adam Finer - Learn BI Online
Рет қаралды 52 М.