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

[@smith9808]

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]

I feel u brother😢

[@tonnaboy10]

Was the same with SSRS too 😫

[@jray1429]

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]

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]

Now think about programmers 😉

[@CoumbaSACKO]

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.

[@davidkovarik483]

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

[@HowtoPowerBI]

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

[@piotrkuc8936]

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

[@HowtoPowerBI]

Hope so! 😊

[@findthetruth3021]

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.

[@Cahangir]

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.

[@SweetPeachannel]

where can I find button slicer on the PowerBI menu?

[@PeterKontogeorgis]

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]

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

[@amoestvitaeessentia]

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

[@SergiyVakshul]

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]

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

[@mustafaragab4400]

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

[@alinespinosi6333]

Very good content, it helped me a lot, I just have a doubt, how do I put the select all with image?

[@mateuszlika2652]

Omg this looks so cool!

[@razagdr]

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

[@HowtoPowerBI]

thank you ! 😊

[@franklinasonofgod]

Agreed 💯

[@shashi369]

A big fan of yours ❤❤❤❤

[@klaraboudova3336]

Great video!! However unable to add measure into the Image filed :( any solutions?

[@hongyangtan9897]

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.

[@Kirtisharma190]

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....

[@arbazahmad7177]

Excellent approach for toggle button. Thanks for sharing 👍

[@HowtoPowerBI]

thx! 😊

[@AbhishekGupta-sz2li]

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?

[@davidm00ris]

Great examples to highlight the capabilities. Thanks!

[@HowtoPowerBI]

thank you David! 😊

[@LinhTran-ys1mt]

amazing visual style

[@natalyakonovalova_]

Please help... At 21:34 minutes... the button size is clearly smaller than the "space provided for them". I can't find how to disable "reaction" (adjusting the button size to the size of the visualization frame)...

[@maikelgoncalves]

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

[@HowtoPowerBI]

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

[@alex...g]

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

[@HowtoPowerBI]

yea indeed, 10 is a bit of a random limit

[@olexiydrozd]

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

[@paamartins]

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]

Same frustration here

[@maximmelnik4222]

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

[@wilconagtzaam587]

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]

thanks Wilco! I'm looking forward to them 😊

[@anubhasinha2557]

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.

[@MarcoAntonio-yj4br]

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

[@HowtoPowerBI]

I appreciate that! 😎👊😊

[@rodrigomenezes_souza]

You are amazing!!!!

[@HowtoPowerBI]

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

[@harikrishnareddy2700]

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

[@HowtoPowerBI]

😅 i wish!

[@anthonybulteaupro5284]

Thanks so much for this qualitative video !

[@HowtoPowerBI]

Glad you enjoyed it! 😊

[@ezekiel0606]

you are an artist

[@HowtoPowerBI]

thank you!!! 😊

[@RajaP-cu3hb]

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

[@jbauer22275]

Love it Bas!

[@HowtoPowerBI]

thank you!!! 😁

[@Arunnehru123]

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

[@HowtoPowerBI]

Thank you so much 😀 that was quick!

[@Arunnehru123]

​@@HowtoPowerBI❤

[@raduciou]

how do you get a fixed pill size when there's less rows than default. I'm trying to do something like you do and when I have two items it always takes whole space making buttons big and ugly. not like your case where they stay same size

[@Goyusuff]

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

[@KuzmaKapper]

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

[@HowtoPowerBI]

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

[@Acheiropoietos]

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

[@brianford7150]

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????

[@steven51612]

Another amazing tutorial. Thank you

[@HowtoPowerBI]

thank you for watching Steven! 😁

[@ОлегПетров-ю4п]

Thank you so much for this content!

[@HowtoPowerBI]

thx for watching! 😁

[@Skoo84]

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]

here is the toggle with the bookmark nav kzbin.info/www/bejne/a4KwoZZrm7qJaKs

[@Hester1]

Amazing new feature! Thanks for this video 🤩

[@HowtoPowerBI]

Definitely is! :D Glad you like it!

[@Why_not_Madhu_Gowda]

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

[@raphaels.1238]

Excellent as always ! Thanks a lot ! 🙏

[@HowtoPowerBI]

thank you!!! 😁

[@IonbeamGreg]

Very cool video . Thanks.

[@inkuban]

Interesting toggle button composition. There should be a way to save the composition as macros or templates. Someone open the request on Power BI features, please; I am just too lazy at the moment.

[@mebong123]

Excellent Bas. Thank you!

[@HowtoPowerBI]

thanks for watching!!! 😁

[@dominiksch4928]

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

[@HowtoPowerBI]

THANK YOU! 😊

[@Palak2977]

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

[@Nalaka-Wanniarachchi]

Cool,Very detailed unboxing !!!

[@HowtoPowerBI]

thank you! 😁

[@egbertdejong6377]

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

[@ЮрийТренов]

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?

[@biniauliya]

Hi im new in power BI and i use power BI aug 2024 version, in my power bi only 3 menus appear, i cant find the button menu, images etc. can somenone help me to solve this problem

[@gioedo2003]

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

[@shivmantra1406]

@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?

[@greenguardian]

is it possible if the image is from google drive?

[@lucasmendoncaoficial]

Great vídeo... Tks

[@klaudiaw2105]

Great video, thanks!

[@HowtoPowerBI]

Glad you liked it! 😎👊

[@Lida-l7b]

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?

[@AnnaWho13]

I have a page where users can search for a particular ID and it shows the details for that record. Is it possible to add an arrow so users can navigate to the next ID or prior ID instead of having them search for the next record?

[@HowtoPowerBI]

create a numeric parameter table based on IDs. Then a filter measure that applies a filter to the visual(s) based on the selected id in a slicer

[@ChristianPecksteiner]

So good

[@HowtoPowerBI]

thank you Christian!!!

[@tpedelaborde]

Does anyone know why this isn´t working when publishing in power bi service?

[@julianatorressanchez5250]

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

[@IbRahimMohzari]

12:00 if pictures from PC or google drive - Is there any way for uploaded ?

[@HowtoPowerBI]

postimages.org/

[@unowho117]

hmmm I wish I could use the new slicer but as a dropdown..

[@andrewlu8432]

Excellent Vedio! thanks

[@HowtoPowerBI]

Thanks!!! 😊

[@dominiksch4928]

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

[@HowtoPowerBI]

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

[@BrigadieruBrokastis]

how did he remove the white background for the PNG?

[@HowtoPowerBI]

so I chose the img i wanted to have in ppt, then right click on the img, saves as img

[@jenniferdustin8214]

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]

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

[@Acheiropoietos]

Thought so, oh well. Another great presentation Bas!

[@dubal2675]

Can SVG be used instead of PNG?

[@HowtoPowerBI]

believe not .. or not yet

[@musl1618]

That's unbelievable))

[@HowtoPowerBI]

thanks!!

[@MarcoNoordam]

Bas is the Bob Ross of Power BI 😄

[@HowtoPowerBI]

😅now only still his haircut .. "I'm going to put a liiiiittle slicer riiiiiight over there.... just like so"

[@danielascibilia4608]

any alternative to dropbox for import images? Thanks!

[@HowtoPowerBI]

postimages.org/ .. any cloud service that can host your images and provide you with a public link

[@Goodheart143-f6q]

How to get that Slicer

[@1yyymmmddd]

Shame it only allows 10 columns without scrolling. No way to use to list 12 months. Otherwise quite cool. Thank you for great video !

[@HowtoPowerBI]

yea 10 sounds like a random limit... lets hope they change it

[@liam271815]

Has anyone encountered issues attempting to do this when the image is saved in a company sharepoint / onedrive location? Any advice?

[@danieviljoen5911]

yes, I try. i also what to know how. Bas, can you help?

[@timguha7762]

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]

thank you! just make sure it is a public link

[@tigitang8719]

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

[@Patrick-d7t]

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

[@malualves6955]

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

[@luisalbertohernandezbenite6732]

I've been trying so hard, to show the images in the report once has been published , but the images doesn't show.

[@HowtoPowerBI]

are the images on a publicly accessible url? try this postimages.org/

[@luisalbertohernandezbenite6732]

@@HowtoPowerBI I solved it, after looking everywhere I found a post from somebody with the same issue and turns out it was for my web explorer I was using Mozilla and I don’t know why it has this trouble, had to change to Chrome and everything works.

[@findthetruth3021]

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.

[@ngeraidine]

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

[@HowtoPowerBI]

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

[@ngeraidine]

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

[@HowtoPowerBI]

yes works @@ngeraidine

[@cgs3478]

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]

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

[@ryan19899]

Hello Bas, is it possible to match the slicer button colors to colors of columns in a column chart?

[@JonathanCHANAL]

in theory, yes with conditional formatting, but I think it doesn't work yet

[@ryan19899]

@@JonathanCHANAL That KZbinr Chandoo has managed to do it in his latest video, but it seems like a lot of work.

[@HowtoPowerBI]

yes conditional formatting would be the way to go - why wouldnt it work yet?

[@JonathanCHANAL]

@@HowtoPowerBI I tried with, for example, a selectedvalue on a single selected item and it doesn't work (a very fast test).

[@rezag.7349]

Has anyone investigated the faulty behavior: When you select a couple of buttons and change to another view e.g. page, then we you come back your selected buttons are no longer selected!

[@RobertoGiuli]

Excellent feature, but sync slicer no work

[@stephanemesnildrey105]

Top🇨🇵

[@Botemedlet]

Apparently, you can only add 10 buttons per row. :(

[@HowtoPowerBI]

yeaaa I know .. feels a bit unnecessary to put a limit on it

[@kidmania3327]

🎉🎉🎉

[@pavankumralle7790]

1st comment 1 view 🎉

[@HowtoPowerBI]

🎉🍻woehoe! impressive 😁

[@TAREKALSHIPLY]

Awesomes 🤍🤍

[@Wzxxx]

This padding and extra space is so dumb. Why MS did it? Always not centered

[@HowtoPowerBI]

😅 I feel your frustration

[@shashi369]

A big fan of yours ❤❤❤❤

[@dylanbuckley8480]

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.

[@shashi369]

A big fan of yours ❤❤❤❤

[@omarbn92]

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

[@dustyarcher]

Great video buddy! Absolutely love it… thank you!

[@ivyzhu394]

Hi, is there a way to the button slicers link to a bookmark when selected? What I'm trying to do it when different product is selected, i have a different page layout, different visuals. I finished everything including creating the bookmarks... then found out there is no action tab on the button slicer... so it's not 100% a button...