NEW Button Slicers in Power BI | 3 Examples You Don’t Want to Miss!

Подписаться 215 тыс.

Просмотров 124 тыс.

50% 1

The NEW Button Slicer is really cool, here are 3 practical show cases you must see. Step by step I show you everything you need to know and how to get the most out of this new feature.
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:40 The Old Button Slicer
02:42 An Overview of the New Button Slicer
09:20 Example 1: Image Effects
16:13 Example 2: Checkmarks for Selection
29:25 Example 3: Toggle
37:47 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

Наука

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

19 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 230

@smith9808 6 месяцев назад

What I hate about Power BI is how much effort you got to go through to create something that looks so simple in this modern world. You spend hours changing loads of settings to do things like this and when someone looks at it, they will assume this is just a standard feature and not be impressed. Only Power BI users know the struggle and the amount of effort it takes to make something look decent.

@thatgoanguy4427 6 месяцев назад

I feel u brother😢

@tonnaboy10 6 месяцев назад

Was the same with SSRS too 😫

@jray1429 5 месяцев назад

Sometimes I wonder if they have a lot of these features and updates already completed and are just slowly releasing it. Tableau does some things in a funky way too. It has its own quirkiness. They definitely operate differently, both have their strengths and weaknesses. I use both.

@ngontran 5 месяцев назад

I reckon. Don’t understand why Microsoft won’t make it for us as developers, so we don’t have to go through a heavy customisation process like this. 😅 However, thanks to this channel, I found a lot of useful tips and tricks to help me make my dashboard looks awesome

@iwalwila 5 месяцев назад

Now think about programmers 😉

@omarbn92 6 месяцев назад

Amazing how creative and quick you can implement new PBI releases as use cases. You are the best !

@CoumbaSACKO 5 месяцев назад

I find myself drawn to this channel, unable to resist the temptation to watch video after video. The level of skill demonstrated is truly captivating, and I appreciate the generosity in sharing such valuable knowledge. Thank you for this enriching experience.

@robmooney1941 6 месяцев назад

I overlayed a transparent button slicer on top of the new card visual to make data card slicers. The accent bar for selected value on the slicer made it a nice touch! Thanks for the videos Bas you put out great content

@davidkovarik483 6 месяцев назад

The quality of your videos is next level - from the content to the editing - everything is top quality. Thanks.

@HowtoPowerBI 6 месяцев назад

thank you David! That's really nice to hear 😊

@razagdr 6 месяцев назад

Bas, your expertise is truly exceptional! Thank you for continuing to educate us. Eagerly anticipating your upcoming training course.

@HowtoPowerBI 6 месяцев назад

thank you ! 😊

@franklinasonofgod 6 месяцев назад

Agreed 💯

@AliAbbas-ik9ix 6 месяцев назад

Excellent ...your expertise is truly exceptional! Thank you for continuing to educate us. Eagerly anticipating your upcoming training course.

@PaulEBrownbill 6 месяцев назад

Very good video with great examples and walk-through. Thanks Paul

@maximmelnik4222 5 месяцев назад

Hi Bas, thanks a lot! It was very useful for me!

@mustafaragab4400 2 месяца назад

Please keep up these tutorials .. it's very beneficial

@Cahangir 6 месяцев назад

I am not even into Power BI that much but gotta tell you, you are really good at what you do. Keep up the good work.

@Machende100 4 месяца назад

Excellent instructions how to improve!!

@Viren1904 6 месяцев назад

Thankyou so much your creative idea its very impressive, i have all implemented in my organisation, my management is shocked how to prepare with new format and dax fuction . So. Again thanky so much....

@chiranjeevi80884 4 месяца назад

Great work, Thanks a lot 🙏

@PeterKontogeorgis 6 месяцев назад

Amazing stuff Baz. What a great update - you must have been very excited when this one dropped! Can’t wait to blow everyone’s minds with one of those image pill buttons.

@HowtoPowerBI 6 месяцев назад

thanks peter! yea, was about time those slicers got a bit of love! lol

@user-lp9yt6kk8r 6 месяцев назад

Thanks Bas, your videos and knowledge is really awesome ! I always watch your videos and appreciate your presentation skills !. Button visual slicer is really great, I like image feature and high level of customization we have. One thing I noticed though is the slicer doesn't keep your selection when you come back to it from another page (on which we don't have it). Do you have any suggestion on how to handle this issue.

@davidm00ris 6 месяцев назад

Great examples to highlight the capabilities. Thanks!

@HowtoPowerBI 6 месяцев назад

thank you David! 😊

@olexiydrozd 6 месяцев назад

I always admire how you do it 😮 thanks for the video, very cool)))

@claudia1953 15 дней назад

Thanks a lot!!

@mehdid.1022 Месяц назад

Awesome, thanks good sir!

@hongyangtan9897 6 месяцев назад

Hi Bas, thanks for the great content. May I ask, is the image works with image that not url link? Like images save in onedrive/pc/table in power bi. Thanks in advanced.

@vickypathak6301 6 месяцев назад

Hi Bas, Amazing work as always, on a different topic I am wondering is there any way we can move grand total column to left in Matrix visual?

@IonbeamGreg 6 месяцев назад

Very cool video . Thanks.

@arbazahmad7177 6 месяцев назад

Excellent approach for toggle button. Thanks for sharing 👍

@HowtoPowerBI 6 месяцев назад

thx! 😊

@CAROLJOHANOTEROGOMEZ 6 месяцев назад

Thank you Bas!!!

@user-ib9mp5ff3q 6 месяцев назад

BAS, thank you so much for your videos. Just super useful material. Could you advise, is there any universal way to show data of Topn and Others without having to create many additional tables for each table with an additional row Others?

@wilconagtzaam587 6 месяцев назад

Great video Bas as always! I know there are still many improvements to make, I can tell you a lot more improvements for the slicer are in the pipeline for the coming months!

@HowtoPowerBI 6 месяцев назад

thanks Wilco! I'm looking forward to them 😊

@raphaels.1238 6 месяцев назад

Excellent as always ! Thanks a lot ! 🙏

@HowtoPowerBI 6 месяцев назад

thank you!!! 😁

@user-ef4oc3vc6r 6 месяцев назад

Thank you so much for this content!

@HowtoPowerBI 6 месяцев назад

thx for watching! 😁

@steven51612 6 месяцев назад

Another amazing tutorial. Thank you

@HowtoPowerBI 6 месяцев назад

thank you for watching Steven! 😁

@anubhasinha2557 6 месяцев назад

Amazing Tutorial Bas😀!!! Could you make a tutorial on how to create a download button to download powerbi visual in the downloads folder instead of cloud.

@lucasmendoncaoficial 6 месяцев назад

Great vídeo... Tks

@mebong123 6 месяцев назад

Excellent Bas. Thank you!

@HowtoPowerBI 6 месяцев назад

thanks for watching!!! 😁

@brianford7150 3 месяца назад

Great video! Thank you for your time on these. I have a slicer visual with 5 buttons, and 2 of the 5 buttons I need to highlight individually. Do you have ideas on how to highlight? I am trying to highlight 2 buttons bright Orange based off the name, "Product X" and "Product Y" for a client, any ideas????

@MarcoAntonio-yj4br 6 месяцев назад

Bas, you are the best. Thank you so much for this content!

@HowtoPowerBI 6 месяцев назад

I appreciate that! 😎👊😊

@josefedericopresno6668 6 месяцев назад

Thanks a lot, Bas, The best video by far of this new feature.

@HowtoPowerBI 6 месяцев назад

thank you!! 😊

@LinhTran-ys1mt 6 месяцев назад

amazing visual style

@anthonybulteaupro5284 6 месяцев назад

Thanks so much for this qualitative video !

@HowtoPowerBI 6 месяцев назад

Glad you enjoyed it! 😊

@unnikrishnansanthosh 6 месяцев назад

awesome, thank you for sharing

@HowtoPowerBI 6 месяцев назад

Thanks for watching again!

@juancho.landero1006 6 месяцев назад

No entiendo porque no tienes más suscriptores ..... eres genial!!!! ❤

@Nalaka-Wanniarachchi 6 месяцев назад

Cool,Very detailed unboxing !!!

@HowtoPowerBI 6 месяцев назад

thank you! 😁

@user-ux6dy2ko3k 6 месяцев назад

Hallo Bas, Thanks for this nice video! is it also possible to add a bookmark to the new slicer buttons, this would be very useful for me?

@klaudiaw2105 6 месяцев назад

Great video, thanks!

@HowtoPowerBI 6 месяцев назад

Glad you liked it! 😎👊

@apcorreia2005 6 месяцев назад

Another great video BAS, congrats. With this slicer buttons, i can't show the last selection(filter) user made when he opened the report. The user has to select every single time. why?

@Skoo84 6 месяцев назад

Great video! I'd like to you this with bookmarks, like clicking on toggle would show another chart, but it would require a slightly different approach. I also noticed that I can't filter out bookmarks from the bookmark navigator since the new update.

@HowtoPowerBI 6 месяцев назад

here is the toggle with the bookmark nav ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5QMpc5fUV2I.html

@Hester1 6 месяцев назад

Amazing new feature! Thanks for this video 🤩

@HowtoPowerBI 6 месяцев назад

Definitely is! :D Glad you like it!

@juanignacioXI 6 месяцев назад

This is amazing Bas!! super valuable video, thanks a lot sir.

@HowtoPowerBI 6 месяцев назад

😁😊 thanks!

@dominiksch4928 6 месяцев назад

your content is btw exceptionally good as usual. thanks a lot

@HowtoPowerBI 6 месяцев назад

THANK YOU! 😊

@edwinarchico439 6 месяцев назад

Excellent bas, as always i am looking forward to your videos😊

@HowtoPowerBI 6 месяцев назад

Thank you so much 😀

@alex...g 6 месяцев назад

So awesome. I wish we could have more than 10 rows/columns, but I'll take it for now!

@HowtoPowerBI 6 месяцев назад

yea indeed, 10 is a bit of a random limit

@lmk001 6 месяцев назад

Neat. Can't wait to play around with it

@HowtoPowerBI 6 месяцев назад

😊 lots to explore , have fun ;)

@SergiyVakshul 6 месяцев назад

Hi, Bas. The approach when Category slicer narrows down SubCategory slicer’s values has a negative side effect. When you change Category_1 to Category_2 the previously applied SubCategoy_1 filters still stay applied. That’s why your chart looks like there is no data when Category is changed.

@HowtoPowerBI 6 месяцев назад

thats true - would b nice to have some "clear other slicer on switch" functionality

@maikelgoncalves 6 месяцев назад

wow, new visual are getting amazing and your videos are awesome bro.

@HowtoPowerBI 6 месяцев назад

😎👊 thank you! indeed the latest visual updates are good, hope they keep on going

@piotrkuc8936 6 месяцев назад

Hopefully, folks from PowerBI team are watching you and implementing your suggestions😊

@HowtoPowerBI 6 месяцев назад

Hope so! 😊

@findthetruth3021 6 месяцев назад

Hi, I have a very difficult question and I searched through the Google and chatgpt and everywhere but couldn't find a solution for that. I have an idea to combine two different maps one is going to be in shape file and the other one is going to be point map. So my idea is to make the background of the point map transparent and only leave the points by latitude and longitude so that I can make a group of points by latitude and longitud with the shaple file map and putting the points by latitude and longitud over the shape file. Finally, make them on group which will appear like that I have both shaple file plus points by latitude and longitud together. But until now I couldn't find a solution how to remove or make the point map background transparent or without having any colour except the points by latitude and longitud. Please help me in this regard. Thanks in advance.

@rafaelsokol8425 4 месяца назад

Thanks, very helpful, and interesting. Only one small problem: I have my images in SharePoint folder, and I can't get it to work. Should I change the link different than in this video (raw=1)?

@andrewlu8432 6 месяцев назад

Excellent Vedio! thanks

@HowtoPowerBI 6 месяцев назад

Thanks!!! 😊

@jadwiga8759 6 месяцев назад

Bas, is there any way to force selection on a slicer NOT set to single-select? For context, I added a field parameter to my report to enable users to choose columns shown in a table -- unfortunately when they open the report the button slicer is by default set to select(or deselect?) all options, making the table too big to load, resulting in a lot of frustration from business. If I select any one option from the slicer, the table loads instantly so I'd like to set it by default that 1 selection -- is using a bookmark with 1st option selected my only option?

@rodrigomenezes_souza 3 месяца назад

You are amazing!!!!

@HowtoPowerBI 3 месяца назад

😁 naaah just know how the new slicer works 😅 thank you!

@julianatorressanchez5250 6 месяцев назад

HI Bas, if I take the link from my microsft one drive, what should I change in the link?

@amoestvitaeessentia 5 месяцев назад

Hiii, i love your channel :D but i didnt get it how to remove white background from the check :(

@ChristianPecksteiner 12 дней назад

So good

@AbhishekGupta-sz2li 2 месяца назад

This was an excellent clip however I can't get the image url to read from my one drive business folder. Can you please help?

@RajaP-cu3hb 2 месяца назад

How can we make slicer buttons can be actionable to navigate another page with the filtered data? like page navigation?

@ezekiel0606 6 месяцев назад

you are an artist

@HowtoPowerBI 6 месяцев назад

thank you!!! 😊

@user-sh3md4gg2q 3 месяца назад

As usual Awesome!! I have a doubt!! Is that possible to add the images from local path?

@HowtoPowerBI 3 месяца назад

thank you! no, that's not possible

@jbauer22275 3 месяца назад

Love it Bas!

@HowtoPowerBI 3 месяца назад

thank you!!! 😁

@emilygeorge1452 4 месяца назад

Do you still need to use the same raw statement if you’re taking the url link from one drive instead of drop box?

@dylanbuckley8480 5 месяцев назад

If I was the ceo of Microsoft the first thing I would do is spend a billion dollars and buy Framer. I would take the tech and hire a bunch of UI designers and transform excel, Bi and PP into a modern package. Then I would roll out a full Microsoft store for low priced components to add to your designs. You could sell everything from macros to buttons and make your entire portfolio drag and drop.

@ArunEnvisions 6 месяцев назад

5th like & 2nd comment 😍😍😍😍.... I spent most of my time here only.... Great RU-vid Channel 💐💐💐

@HowtoPowerBI 6 месяцев назад

Thank you so much 😀 that was quick!

@ArunEnvisions 6 месяцев назад

@@HowtoPowerBI❤

@harikrishnareddy2700 Месяц назад

You can bend any feature in PBI according to your will... 😂😂 That was a wonderful info. Thank you very much.

@HowtoPowerBI Месяц назад

😅 i wish!

@jenniferdustin8214 6 месяцев назад

I love this! Any idea if they are going to give us this functionality with Nav? Or a way to use a slicer instead of bookmark navigator?

@HowtoPowerBI 6 месяцев назад

I think to trigger page navigation actions you would need to rely on the bookmark nav

@Acheiropoietos 6 месяцев назад

Thought so, oh well. Another great presentation Bas!

@musl1618 6 месяцев назад

That's unbelievable))

@HowtoPowerBI 6 месяцев назад

thanks!!

@SweetPeachannel 27 дней назад

where can I find button slicer on the PowerBI menu?

@thanksBAS 6 месяцев назад

Hey Bas, great work. Can you write specs of your PC? It's works very smooth. I'm looking now for a new hardware. Many thanks.

@HowtoPowerBI 6 месяцев назад

Got a lenovo p1 gen 3 , 32gb ram , intel i9 … lot of overheating. Probably next time i buy lenovo x1 yoga 32gb i7

@Acheiropoietos 6 месяцев назад

My boss is colourblind so I have to use the colourblind theme for all my reports. I am adding extra colours gradually though. 👍

6 месяцев назад

perfect!

@HowtoPowerBI 6 месяцев назад

THANK YOU!

@gioedo2003 6 месяцев назад

Hi. first of all I would to congratulate for your channel and for your videos. I need to create a dashboard with this flow: 1. the user opens the dashboard and finds a menu where he sets several parameters such as a date picker parameters, a dropdown menu etc. 2. click the "GO" button and the query starts which extracts the data with the query set by the user's setting 3. Once the upload is complete, the user can move to the page where he can analyze the data just downloaded. Is it possible to do this with Power BI? How? Thanks

@Goyusuff 3 месяца назад

How do i Change the orientation of my visual pane from vertical view to horizontal view

@germanleonardofigueroapuli1096 6 месяцев назад

hi Bas, you know if when it's published as web public report that new slicer work correctly?, because when publishing a report the segmentation buttons are totally useless, has anyone been same issue?.... and thanks for yor work its amazing!

@NarendranBI 6 месяцев назад

Ya, I too face the same Issue. After switch off the Accent bar it works. Give a try.

@alicedwonderland7733 6 месяцев назад

Bas, of course, fantastic video! Found a bug with the slicer though, just when I was ready to push it to prod. Say you have one (using your first example) in multiple pages, and they are synced. Also say that only one value (out of, for example, five) is selected by default... Unfortunately, it will automatically jump to selected them all after moving between the tabs a few times. Also, in the online version, the 'reset filters' icon stops working. Like, you keep clicking it, and it does not reset. Had to back out...

@Guillaume128 5 месяцев назад

Yeah so frustrating… Many users reported thoses slicers sync issues in the dev blog comments, let’s hope they fix it as soon as possible…

@alicedwonderland7733 5 месяцев назад

@@Guillaume128 just realized I stopped thinking about this feature after this bug prevented me to use it in the first place. This has to be a warning for us - make great reports and, above all, address ALL early bugs asap, or else people will not start to use them and forget about them.

@KuzmaKapper 2 месяца назад

TY! Please help me to understand - how can I use OneDrive link instead of DropBoxlink in DAX measure creating!

@HowtoPowerBI 2 месяца назад

right click on the image, copy link and open it in the browser. Then take the url that shows in the browser (you will see it change) and remove everything after the last ? .. then add download=1 .. copy the updated url and use it in power bi

@dubal2675 22 дня назад

Can SVG be used instead of PNG?

@misiek6931 6 месяцев назад

Hi, well explained :D. Got one question, is it only me or the font color doesnt apply for "select all" option for this preview feature?

@HowtoPowerBI 6 месяцев назад

for me the color shows correctly

@PowerBIRocks 5 месяцев назад

Great video! At 12:20 - I am unable to add the measure in the image "Add Data" field - any ideas why?

@PowerBIRocks 5 месяцев назад

Nvm - the data type needs to be Text for the measure to work haha!

@paamartins 6 месяцев назад

Hi Bas, I can't make it work with SharePoint images. Is there any trick similar to what you did with the "raw=1" that I should apply? I can see a space applied, but the image is not displayed.

@charleshouedjissi9969 6 месяцев назад

Same frustration here

@timguha7762 6 месяцев назад

Genius as ever. If I have image files in OneDrive rather than Dropbox, is there something i need to do to the link to show the image? Thanks and keep up the excellent work! Thanks.

@HowtoPowerBI 6 месяцев назад

thank you! just make sure it is a public link

@tigitang8719 5 месяцев назад

Hi Bas. Thanks for the awesome video. To make it public, do you click on "Share." In the "Share Settings," select "Anyone"? I did that but it didn't work. Did I miss something? Thanks a bunch..@@HowtoPowerBI

@user-sb9ol6ib5i 5 месяцев назад

i have the same Problem - i tried Google Drive and also Sharepoint@@tigitang8719

@malualves6955 4 месяца назад

It didnt work for me too@@tigitang8719 you had any success?

@anshikapandey2977 6 месяцев назад

How I can use images which are online available which I have pasted in my excel sheet? I have been trying to do so but no avail

@ngeraidine 6 месяцев назад

Master, as you did to place the images in the botal, you could use the expression DAX allselect instead of MAX ?

@HowtoPowerBI 6 месяцев назад

no, max returns here the selected item. allselected serves a different purpose, it would return all values in a column.

@ngeraidine 6 месяцев назад

@@HowtoPowerBII wrote the word, que correct expression DAX is SELECT VALUE. is it works too? Rugs from Brazil

@HowtoPowerBI 6 месяцев назад

yes works @@ngeraidine

@vanessagardellin 12 дней назад

Hey, thanks! I got a question for you. I noticed that if I use a slicer and my text goes over 3 or more lines, the padding keeps increasing and increasing and I need to do a very big button to fit in. Do you have any trick for this?

@egbertdejong6377 6 месяцев назад

Great (unexpected) ending. Unlikely MS/Miguel thought of this 😉

@shivmantra1406 4 месяца назад

@bas can I ask what is the risk of pointing to an external website for an image? Will it open my organisation's report to hacking?

@Why_not_Madhu_Gowda 3 месяца назад

Are we able to create a toggle button in the mobile layout? If we are able to do then how? please reply me

@user-sb9ol6ib5i 5 месяцев назад

does it also work wirh google drive? Didnt work with me

@kushace4 2 месяца назад

Hello Bas! I tried this new slicer in my report, however i am still unable to insert any images into slicers! i have followed every steps such as data category changed to “IMG URls”, I draw the table into report image urls, but still i am unable to figure it out what’s going wrong with it! Seeking for your valuable reply!

@cgs3478 6 месяцев назад

Could you please do more videos with cool stuff that can be done in folder versions of Power Bi? Unfortunatelly, not all the receivers of our reports are willing to update every time a new version comes out thus making the developers stick to older versions ( from 2021 or 2022)

@HowtoPowerBI 6 месяцев назад

got over 100 videos for you to watch with all kind of tricks for those versions! check out the channel page

@findthetruth3021 6 месяцев назад

@kassiowifried 6 месяцев назад

Good job

@HowtoPowerBI 6 месяцев назад

😎👊

@dominiksch4928 6 месяцев назад

Isn't it possible to play around with padding to format your toggle circle?

@HowtoPowerBI 6 месяцев назад

a little bit .. but there is padding you cant get rid off

@natsarev 6 месяцев назад

As soon as I learned about this update I immediately thoughts that Bas must be exited now 😂 Btw you can sample color of any element outside of power point directly from power point. For that you need to pick eyedropper, press it on any element in power point and keeping it pressed drag coursor outside of ppt window and release once it's on the element, the color of which you need (hope that explanation is clear))

@HowtoPowerBI 6 месяцев назад

awesome didnt know that thanks! .. though usually i press a btn on my stream deck for it :D