Тёмный

PIMP MY SLICER | Improving the DESIGN of Native Slicers in Power BI - Step by Step 

How to Power BI
Подписаться 214 тыс.
Просмотров 173 тыс.
50% 1

Looking for ways to pimp the slicer? Look no further"
In this video I show you the steps I take to improve the design of native slicers in Power BI. In this complete walkthrough you learn about how to make smart use of the formatting options and tricks to take your slicers to a whole new level.
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
01:20 Button Slicer
02:43 Borders
04:51 Working with shapes
07:32 Horizontal layout
09:00 Vertical slicer - basic formatting
10:40 Vertical slicer with custom check boxes - bar chart method
17:45 Integrating error bars for more options
19:42 Vertical slicer with custom check boxes - table method
27:14 Slicer dropdowns
29:15 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 RU-vid: 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

Наука

Опубликовано:

 

15 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 162   
@HowtoPowerBI
@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
@lucascosta2729
@lucascosta2729 Год назад
Hello! Greetings from Rio de Janeiro in Brazil! I've been learning for 6 months with your video contents about power BI and recommending it for other people in my neighborhood. Thanks for the content and great success!
@samuraize24
@samuraize24 Год назад
This Guy ! OMG.. my creativity lvl just droped -100
@HowtoPowerBI
@HowtoPowerBI Год назад
:):) slight exaggeration?
@user-tr2gz3ok5e
@user-tr2gz3ok5e 7 месяцев назад
As usual, your set skill is endless! I spend countless hours watching and practicing with your videos. I wish I had enough dashboards to develop to incorporate 1/4 of your awesome work!!!!
@HowtoPowerBI
@HowtoPowerBI 7 месяцев назад
I bet your company would love for you to create 4x more reports ... just not sure if they would also pay you 4x 😅
@EldinjoN
@EldinjoN Год назад
Love these design tutorials! I've been using your tips & tricks a lot lately, thank you!
@HowtoPowerBI
@HowtoPowerBI Год назад
Awesome Eldin! :):)
@JohnSmith-yw7tg
@JohnSmith-yw7tg Год назад
I discovered your channel by chance (somehow the algorithm proposed one of your videos in my feed). I love your videos. Very well presented, very detailed. They're just fantastic!
@serenatmacar1431
@serenatmacar1431 Год назад
I kind of wait for your videos just like waiting for the next episode of my favorite series… Huge creativity! Thank you for sharing these with us!
@HowtoPowerBI
@HowtoPowerBI Год назад
Ahh Serenat:) this made my day! Totally wanted to be a tv personality… in Power BI ;)
@Amr-Ibrahim-AI
@Amr-Ibrahim-AI Год назад
Wow! This is packed with innovative tricks, and is joyful to watch! Thanks Bas!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks a lot Amr! Much appreciated and super happy to hear it is fun to watch :):) totally my aim
@anthonyflorianterrapon6575
@anthonyflorianterrapon6575 Год назад
Love your videos ! A hot bearded guy with biceps teaching BI... what a blessing
@YasinNabi
@YasinNabi Год назад
I can assure That This is one of The best videos ..... liked
@HowtoPowerBI
@HowtoPowerBI Год назад
Yey! Glad you say so!
@cezaryczajka9198
@cezaryczajka9198 Год назад
Another fantastic (as always) tip! Your videos are eagerly awaited for the next episode of your favorite TV series. I am sure I will apply your tricks to my desktops.
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks Cezary! Hhaha always dreamt about owning a tv channel! ;)
@brandongillins
@brandongillins Год назад
Loved the intro. My feeling exactly!
@arvindsinghrawat538
@arvindsinghrawat538 5 месяцев назад
Every second of your video is a gem❤
@hashtag_pete7304
@hashtag_pete7304 Год назад
Great video, as always - and the first seconds speak from my heart! A tip for the disconnected table: create one with VALUES. When another category will be implemented, you don't have to maintain the manual input. Works just as fine.
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks Pete :)
@erickung4302
@erickung4302 Год назад
Amazing video Making Power BI design better everyday!! You're amazing!!
@oneashen4250
@oneashen4250 Год назад
thank you. I've learned a lot from your videos, i'll apply this design for my slicer right away.
@HowtoPowerBI
@HowtoPowerBI Год назад
Awesome! 😎 let me know the result :)
@leonberlang1397
@leonberlang1397 Год назад
Awesome video like always, Bas! Huge inspiration. Hope Microsoft gives us more conditional formatting control in the base visuals, shapes etc.
@HowtoPowerBI
@HowtoPowerBI Год назад
I also hope for this Leon, but in the meantime….
@ChyAnalyst
@ChyAnalyst Год назад
Love your videos. Thanks Bas. You've really improved my Power BI skills
@HowtoPowerBI
@HowtoPowerBI Год назад
Yey! Totally my goal, very happy for you, all the best!
@cosladacity1
@cosladacity1 Год назад
Aaaaammmaaizing!!!! The last trick with a tooltip option is the best ive seen in a while
@HowtoPowerBI
@HowtoPowerBI Год назад
Yey! Thx Manuel! :)
@alexrosen8762
@alexrosen8762 Год назад
Exactly what I was waiting for and the content was once again at another level👌👏🙏
@HowtoPowerBI
@HowtoPowerBI Год назад
Hey Alex! :) super happy to hear this coming from you! 🙏 thanks
@Tubasnot
@Tubasnot Год назад
Thank you for a great video. Slicers is always one of those things I struggle with visually on reports. Always a challenge to not make them just look bland and dull. This video helped a lot in terms of creative ideas.
@HowtoPowerBI
@HowtoPowerBI Год назад
That’s great! I am super happy it is helpful:) 👍
@coreyayers3623
@coreyayers3623 3 месяца назад
Thanks for continuing to put out solid content! Really well done!
@HowtoPowerBI
@HowtoPowerBI 3 месяца назад
Glad it is helpful, thanks for watching it
@juanignacioXI
@juanignacioXI Год назад
Beautiful work with the Design Bas, keep it up!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Juan!
@mdhidayat5706
@mdhidayat5706 Год назад
Thanks for the video, love how you just use native visual to create this look.
@HowtoPowerBI
@HowtoPowerBI Год назад
:):) thanks!
@gustavopineda7933
@gustavopineda7933 11 месяцев назад
You are awesome bro , simple & efective 👌
@rashane1000
@rashane1000 Год назад
Great content as always Bas. That's a lot of work I'd say and hoping that MSFT can improve/simplify this trick.
@jeromestival3210
@jeromestival3210 Год назад
Thanks for this tutorial ! Very nice ! 😉
@abdulrahmanalnajjar1496
@abdulrahmanalnajjar1496 Год назад
Really, amazing clips You are always creative in creating easy ideas, beautiful designs, and easy and wonderful ways 👍👍👍👍👍👍
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks a lot!
@rafaelnardi4915
@rafaelnardi4915 Год назад
Thank you for the amazing content, as always!
@HowtoPowerBI
@HowtoPowerBI Год назад
super welcome Rafael :):)
@TrassBI
@TrassBI Год назад
Awesome content!👏Thanks for sharing👍
@AlejandroRamirez-hu9yf
@AlejandroRamirez-hu9yf Год назад
Nice - thanks for sharing man!
@rafimd8860
@rafimd8860 Год назад
Salute to your efforts man.
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Rafi!
@spen2431
@spen2431 Год назад
Nice one Bas. Thanks for sharing 💥💥💥
@tarun007
@tarun007 Год назад
Hats Off to your Effort !!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks Tarun, much appreciated!
@MaanEid
@MaanEid Год назад
Thanks Bas for these great ideas!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks Maan!
@hi55us2
@hi55us2 Год назад
Um. I wish I could give this video like 5 likes, one for each part. Mind blown. Hopefully Microsoft improves the tools available for the slicers without these workarounds, but in the meantime these are great, especially the tooltip idea towards the end.
@HowtoPowerBI
@HowtoPowerBI Год назад
:) ah thats nice! Indeed I still dont get how the selected value needs to always be black, even page and bookmark navigation can have different colors on selected state…
@unnikrishnansanthosh
@unnikrishnansanthosh Год назад
thanks for sharing BAS, excellent ideas
@HowtoPowerBI
@HowtoPowerBI Год назад
:):) happy to hear this thx!
@leilabenidjer3983
@leilabenidjer3983 9 месяцев назад
I love all your video 😍.
@balrajsanthosh1942
@balrajsanthosh1942 Год назад
Brilliant Idea Bro, Totally helpful video bro🥰, just waiting for all these to be provided as part of conditional formatting by Microsoft so that it saves a lot of time and adds more value to the tool
@geineralbertomejiagarzon4034
Awsome Bro, you are so great, definitly you take PBI to the next level... Excelents tricks, I have to apply them.
@HowtoPowerBI
@HowtoPowerBI Год назад
:) glad to hear this! Good luck
@cristianprifti
@cristianprifti Год назад
When generating the department disc table, would it not make sense to do it from Power Query based on the actual dimension to make sure we do not miss new values? Irrespective of this, your videos are amazing!!
@quikin7
@quikin7 Год назад
Really cool videos, man. I am applying your ideas to my job!
@HowtoPowerBI
@HowtoPowerBI Год назад
Awesome 😎 Juan!
@williamthedataprof
@williamthedataprof Год назад
That was epic!
@dcpowered
@dcpowered Год назад
Thanks for another brilliant video, Bas! Here is a challenge for you: how to create a custom legend that fits on page if there are a large number of categories? Instead of having to click to show the rest of the hidden legend. This would be very useful if the report is shared as a PDF or on a big screen where the user cannot click to see the rest of the legend. Thank you!!
@1yyymmmddd
@1yyymmmddd Год назад
Overlaying a picture with the custom legend won't work?
@khairihilmisaputra6620
@khairihilmisaputra6620 Год назад
i never think about it, cool video.
@HowtoPowerBI
@HowtoPowerBI Год назад
:)
@jcjuniorcontatos
@jcjuniorcontatos Год назад
Conteúdo excelente!
@tosinopeniyi1407
@tosinopeniyi1407 Год назад
Amazing trick 👌 👏 🙌 Best in the game. Thanks Bas
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Tosin! Much appreciated:)
@pullururupeshpulluru7165
@pullururupeshpulluru7165 Год назад
its just awesome
@TheActurialRepository
@TheActurialRepository 4 месяца назад
This guy is so ingenious.
@philiposebhavna
@philiposebhavna Год назад
Awesome 👏 😊 🙏 Love ❤️
@ricgondo
@ricgondo Год назад
OMG! Beautiful!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thank you! Cheers!
@user-yo2nb4ry7i
@user-yo2nb4ry7i Год назад
Ну респект. Спасибо за контент.
@datactive859
@datactive859 Год назад
another great video!
@HowtoPowerBI
@HowtoPowerBI Год назад
:)
@Bondoz007
@Bondoz007 6 месяцев назад
Lots of great tips. I have limited space so tend to use drop downs. It would be nice to see more tips for these but i guess it really is limited
@firstch7801
@firstch7801 Год назад
Very professional design, loveit
@HowtoPowerBI
@HowtoPowerBI Год назад
Yey! Super happy to hear this!
@firstch7801
@firstch7801 Год назад
@@HowtoPowerBI I use many of your tips to upgrade my report .please keep making tutorial.😃
@ahmedalkherbi
@ahmedalkherbi Год назад
You are my Boss, Bas
@charlesrios8542
@charlesrios8542 Год назад
This is awesome
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Charles!
@CaucasianEU
@CaucasianEU Год назад
Thank you, for the video. Question: based on this example, what if I only want see as options: Animal Health, Pharma, Vaccines and take away/delete: Business Services and Eye Care
@denisskorikov6234
@denisskorikov6234 Год назад
17:50 still be better?! Great job!
@nicolastalvasson2539
@nicolastalvasson2539 Год назад
Good job !!!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks Nicolas :)
@tomaskavicky
@tomaskavicky 11 месяцев назад
good video as always, Bas, can you do a video about pbi language versions? There are some, but not sufficient
@Navin2718
@Navin2718 8 месяцев назад
Thanks for the learning, is there any way we can show "Select" instead of "All" in dropdown option of the slicer
@datanerd6935
@datanerd6935 Год назад
Love this, your work is on par with Guy in a Cube, keep it up man!
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx for the feedback!
@datanerd6935
@datanerd6935 Год назад
@@HowtoPowerBI A little issue though, in "vertical slicer with custom check boxes" when I click the slicer twice, its own check boxes appear and custom check boxes go into background in PBI Desktop. Is that expected?
@valentinaverissimo5584
@valentinaverissimo5584 Год назад
Show de bola o seu conteúdo...quero replicar..
@ibbyparvy8100
@ibbyparvy8100 Год назад
Very useful 👍
@HowtoPowerBI
@HowtoPowerBI Год назад
Awesome to hear this Ibby!
@piraviperumal2544
@piraviperumal2544 Год назад
Awesome
@PeterKontogeorgis
@PeterKontogeorgis Год назад
Always amazed at how you can use the limited tools available to come up with some nice looking solutions. No chiclet slicer love though? Would be interested to see what you could do with it.
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Peter, loads of clicking around… yeah, you are right- im using native visuals 99.9% of time as not everyone can use custom visuals
@nikosuomi5674
@nikosuomi5674 Год назад
Nice trick :)
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Niko!
@razaulashraf5927
@razaulashraf5927 Год назад
Thanks
@HowtoPowerBI
@HowtoPowerBI Год назад
:)
@szklydm
@szklydm Год назад
I think if they could somehow integrate the formatting options already available for bookmark/page navigator, it would already be a huge improvement but I won't keep my fingers crossed for that - it feels like native visual options have been neglected for a reason
@HowtoPowerBI
@HowtoPowerBI Год назад
Interesting thought, maybe indeed… thankfully there is usually a way to make it look “not horrible” i am 100% native visual guy
@jyotigupta-ch5dk
@jyotigupta-ch5dk Год назад
Ok
@balajir171
@balajir171 Год назад
Waiting for your reply.... I subscribed immediately after seeing one of your videos and couldnt stop referring your tips post that - 😎. I have a big question, if I get the answer I will feel lucky ??????? How to avoid the ADDITIONAL SPACES on the slicer box when we are showing it as a button ?????, It is really annoying when we have multiple slicer. Any tips on this will be a great help.... ?????????❓
@salah232
@salah232 Год назад
thx you
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks for watching Salah!
@piasenica1028
@piasenica1028 Год назад
Hey can you create a content on tooltips being displayed on measures instead of columns? Read it from a website that it’s actually possible thanks!
@naylord5
@naylord5 Год назад
This video is excellent master! Thank you for sharing your knowledge and experience with the community. Can I ask you a question? I have a statement with a list of payments, each movement is associated to a document number, the problem is that the payments can be cancelled N amount of times and reapplied, either to the same doc or to another one. I would like to use Power Query to keep only the last odd (non) occurrence of the payments, but if the number of payments is even, discard them all. That is, if doc 1 had 1 payment, 1 cancellation and 1 payment again, only keep the third transaction, but if doc 2 had a payment and it was cancelled, but it was not paid again, discard all the payments of doc 2. Do you think you could help me? Thanks in advance for your time.
@vaishalisharma5459
@vaishalisharma5459 Год назад
Hi
@kassiowifried
@kassiowifried Год назад
Good job
@HowtoPowerBI
@HowtoPowerBI Год назад
Thanks a lot!
@666Niusia
@666Niusia Год назад
AWSOME! I LOVE THESE TRICKS TO OVERCOME LIMITATIONS:)
@HowtoPowerBI
@HowtoPowerBI Год назад
Happy to hear this thx!! ☺️
@brypie04
@brypie04 Год назад
Did not know you could put uniocode chars in your measure if statement!!! I've been faffing around with conditional formatting all this time!
@HowtoPowerBI
@HowtoPowerBI Год назад
Unicode is life :)
@rafimd8860
@rafimd8860 Год назад
Can we implement RLS on image level
@BluesFanUK_
@BluesFanUK_ Год назад
Have there been any improvements to this in later versions? Seems a major oversight not to allow changing the select colour.
@HowtoPowerBI
@HowtoPowerBI Год назад
Still the same 🤭
@workstuff5253
@workstuff5253 Год назад
@12:40 could you just add a table via DAX with ALL( dimDepartment[Department] ) ?
@HowtoPowerBI
@HowtoPowerBI Год назад
Yes that would be better
@zuhebkhan6973
@zuhebkhan6973 Год назад
Hi sir there is challenging task from my client on the on new, old, recovers and lost customer...sir i can provide the data for u to prepare...the viedo
@yassirkhalid5376
@yassirkhalid5376 Год назад
Great tricks over there There are some problems thought 1. The technique might not work well when a new item/department is added to the data later, at least for the alignment part 2. One needs many non-conected tables, one for each slicer I just hope Microsoft will hire you for one month to fix this issue and come back to us 😅
@HowtoPowerBI
@HowtoPowerBI Год назад
Agree Yassir, it is more for static filters.. definitely it is not ideal but it maybe a solution in some cases… haha 😂 i like it here on RU-vid :)
@paulgallagher2987
@paulgallagher2987 Год назад
You could create the disconnected tables in Power Query by simply duplicating the DIM table and just choosing the column/s you need. That way it would stay current when the departments change.
@gopyjs6216
@gopyjs6216 Год назад
👏👏👏👏
@michaelbrown488
@michaelbrown488 Год назад
you can rename the column to a space character to also make it invisible in a table .
@coltengoll9371
@coltengoll9371 Год назад
Have you used the chiclet slicer? I much prefer it to the native slicer.
@HowtoPowerBI
@HowtoPowerBI Год назад
Agree not a big fan of custom visuals though…
@othmanashara9382
@othmanashara9382 Год назад
finely i got how to change my slicer into horizontal. i got stuck because my slicer was in hierarchy so the slicer setting does not open for orientation options
@HowtoPowerBI
@HowtoPowerBI Год назад
Awesome!
@fatherOfTwins2
@fatherOfTwins2 Год назад
May I have the file .pbix from you? Thankyou
@JGary321
@JGary321 Год назад
Noice!
@DarshanSawant-gf3gt
@DarshanSawant-gf3gt Год назад
anyone knows how to change sequence in slicer?
@DavidGonzalez-ew8zf
@DavidGonzalez-ew8zf 10 месяцев назад
He seguido el tutorial al pie de la letra pero, obtengo todo X cuando selecciono un elemento y si selecciono Ninguno obtengo el Check
@steelcitychampzz4741
@steelcitychampzz4741 Год назад
I’ve got a challenge?!…I need help with creating a MILEAGE report with 3 vehicles. I need to create Average of Miles per WEEK,MONTH, & YEAR using a Date Table. I haven’t been able to find a good function to use in DAX. Need Help 😫😤😂
@yashurv6547
@yashurv6547 Год назад
please explain power app also ....
@HowtoPowerBI
@HowtoPowerBI Год назад
Have a look ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uPHwjPRnRwE.html
@stoneage8810
@stoneage8810 Год назад
in my case the biggest problem was there were many slicers needed on the page and they occupy a big part of space, so less for actual viz........
@HowtoPowerBI
@HowtoPowerBI Год назад
Have a look at the latest video this maybe helpful here The ULTIMATE Slicer Panel in Power BI ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QaOG42ic2wI.html
@shivashankarable
@shivashankarable Год назад
Yes, Power BI is missing simple options which makes it hard to use it
@HowtoPowerBI
@HowtoPowerBI Год назад
Agree
@user-og3ne8gb8c
@user-og3ne8gb8c Год назад
sir, that would be 6,67
@analistax
@analistax Год назад
%!$@#% :Z :| WTF!!! AMAZING!!!!!
@HowtoPowerBI
@HowtoPowerBI Год назад
Hahah thanks :)
@AntoineTerrade
@AntoineTerrade Год назад
Thanks for the video, nice tips. However as it a technical video, you don't need to put your face while you explain.
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx for the opinion, as you may have seen thats the editing i go for for all my videos
@AntoineTerrade
@AntoineTerrade Год назад
@@HowtoPowerBI Yes I saw, but isn't the important thing to watch is what you're showing rather than your face. (Not saying you're ugly :P)
@HowtoPowerBI
@HowtoPowerBI Год назад
Haha I want everyone to remember my face forever ;)
@aartdevletter5822
@aartdevletter5822 Год назад
Nice video! Thanks. Tip: u sound like u "do a voice" instead of just relax and speak the way u normally speak.
@jakob2746
@jakob2746 Год назад
Had to dislike. 6 commercials in such a short video is just unbelievably annoying. Seems greedy.
@HowtoPowerBI
@HowtoPowerBI Год назад
Ok, thats how youtube works. Otherwise premium is a good option if you want to skip ads all together.
@ivanxdxd
@ivanxdxd Год назад
You're using back-end to do front-end. That can't be good practice.
Далее
Tipuan Jenius dalam Mengasuh Anak & Gadget Cerdas
00:21
♀ 🔁 ♂ = ...❓ #OC #늦잠 #vtuber
00:12
Просмотров 1,1 млн
The ULTIMATE Slicer Panel in Power BI
36:15
Просмотров 188 тыс.
4 Power BI Report Design Tricks - THIS IS GOLD!
10:23
Want a BEAUTIFUL Power BI Report? Start here!
6:21
Просмотров 208 тыс.
How to Drillthrough on a Card Visual in Power BI
9:00
Make Impressive McKinsey Visuals in Excel!
16:47
Просмотров 258 тыс.
Build a Slicer Panel in Power BI Like a PRO
20:40
Просмотров 46 тыс.
Bluetooth Desert Eagle
0:27
Просмотров 7 млн