Build a TOGGLE BUTTON Like a PRO in Power BI

Build a toggle button like you've not seen before! No custom images, no overlapping images or buttons - just one native button!
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 [e-mail]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:43 Creating a toggle button - the basics
03:34 Making it look like a toggle button
08:43 Implementing the toggle button
13:19 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 KZbin: 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

[@mmarkstrom1]

I know it's a one year old video but this is gold! The amount of tricks I've learned from this channel is just incredible!

[@chriskeo392]

Why can't I resize ? I selected the font size exactly as you did but it doesn't resize in anyway

[@shlokuniyal1152]

Same issue with me

[@niclaskammler1006]

Because the Borders are active by default. You need to switch borders off to resize the dot

[@rajesm106]

Great tip, as always! I’ve always used multiple images to achieve this, and getting the image with the exact size and colour for every project can be time consuming. This is definitely super efficient especially for mockups to present different options to end user before actually building the full report.

[@wayne8797]

I just built my very first power BI dashboard and I must say it was a very steep learning curve yet extremely satisfying once you get it. The basics are ok, but once you want to go fancy, like using bookmarks with trigger buttons, fancy tool tips that points to pages, or pop up windows and hidden slices, then the fun really begins. I dont know what I was doing with excel for all these years when Power BI had been installed on my laptop all these times lol. Still learning and will definitely give this trick a try.

[@andruboine]

Heck yes.... I'm in the middle of migrating my workspace to new data sources and the timing of your videos this week have been amazing you're going to cut my workload in half and make everything looks 100 times better b

[@j_d4303]

This is a great tip, much cleaner than the way I used to create toggle buttons using 2 overlapping button images! Will definitely be implementing this in to future reports. Great video as usual Bas

[@sujit5581]

After pasting the circle in place of Toggle ON, the size of the circle is not increasing. Kept the state as "Default" but no change in size.

[@leegarrett1908]

Had the same issue only the toggle off would enlarge then I watched your short and it works. Was to do with the border and fill. Thanks

[@fernando_tenorio]

Hello, I've been on the BI landscape for a long time, but I'm just a beginner into Power BI world. I can say that your videos are a motivational source of inspiration to look for not-so-plain-not-so-funny reports/dashboards :) I'm sharing with my team, too. Thanks!

[@HowtoPowerBI]

awesome, glad to hear they help a bit. Thanks for watching and sharing ☺

[@brunolazzarini2351]

I love these creative tips, it really takes the final report to another level and open mind to new ideas. Thanks for that, Bas.

[@catherinegould6662]

This is a great tip - I will be using nav groups in the future, a tip for you... save yourself alot of formatting fiddaling, select Pill shape and 0 px boarder padding

[@IWillMakeYouFamous]

good vid. if you're having issues with the unicode size and font try "ctrl" clicking on the toggle to trigger changes. you may also need to set the states to different states and ctrl click to trigger. glitchy pbi

[@Merrell2780]

Man this one is awesome what I looked for so long! 🎉 Thank you for your great ideas. Please keep doing what you do! I really like your videos and got so much out of it! 👍😀

[@zhenqin6719]

that is a very neat and creative way to create toggle button without overlaying images. bravo!

[@user-po2ze4mj4m]

Always excited to see the valuable content from you Bas!!!!

[@HachiAdachi]

😲🤯 Simply a---MAZING!! Thanks again for the awesome tip, Bas! 🙏 Time to go update a bunch of my old reports with layered toggles! 😑

[@AlkaPandeyalka]

Thank you so much for making this video, I was searching this from so long.

[@rachelrdyer]

Great video, as always, clear, precise and fun to watch. Thank you!!

[@alexgry4763]

Bas, you are awesome! I enjoy how you find creative ways to abuse PBI and build things which I thought were not possible to implement.

[@mrkenny83]

Bas I LOVE you. Have a fantastic 2023!

[@CondeNastCruiser]

I am learning so much from you. Thanks for sharing your expert and creative knowledge of PBI ;)

[@RobertoMassucco1978]

That's brilliant! I was used to create toggles using images, but this version is better

[@ibmyyc]

Hi Bas, as you may have noticed from multiple comments, the toggle text is not resizing and actually not even switching between 2 states. Maybe you can help us troubleshoot this issue. Thanks.

[@kovacsbarnabas2344]

Maybe I solve it randomly. In the visual where you can apply settings to states if you change it to forexample selected from default and you start to resize there than go back to the default you can change the size normally It looks like a bug, but after changing the states it works perfectly fine for me I hope this help

[@brianligat9493]

I saw the title and started building overlapping circles on a pill, then watched the much-better solution. Thanks. Keep up the great tips and techniques. How did you get the click sound effect ? LOL. Of course, you can make the main visual a high-level line, and the second visual a detailed report.

[@___rnd]

Excellent work Bas, you're just awesome.

[@venkat8071]

Hello, My sincere thanks to you for the efforts you take to improve others and to add value to their lives.🙏.

[@ukaszorzechowski5217]

For bad luck desktop version have problem in changing size format of unicode... Well your way cant succeed if you have deselected data option in bookmarks....

[@emky9876]

bro, you are the best ! keep on sharing this kind of videos 👍

[@manoplaeli4027]

I always find it useful with your video, thanks for sharing

[@ramakrishna6954]

Thanks for this. It will be very useful instead of using boring buttons.🙂

[@viniciusfernandes3552]

Love your creativity buddy. Much appreciated. cheers!

[@ozkandhont2481]

Love the creativity behind this toggle button!

[@HowtoPowerBI]

Thank you for watching Özkan! Yea was a lot of trial and error before i got it working with just 1 btn

[@seyisonade1194]

Thanks for the spectacular training resources you give to us... Thanks for the efforts in improving and adding values to others.

[@HowtoPowerBI]

Glad to hear is was helpful! Thx 😊 Seyison

[@amiya217]

you make things easy.. I used to keep 2 images and hope few other developer do so till now..

[@pk231]

Great content usually I use two overlapping images. This one looks cool!!!

[@msriramal]

Thank you, I had a corner case, using a measure to change the table data using switch command, that did not work, this is a work around for my issue.

[@magorzatatomkowicz7362]

Great idea, Bas. I am always amazed at how you make these all tricks with visuals. Your videos are very inspiring. I did the toggle button as you showed in this video, but somehow I can't read off some very thin border around the border. The border color is the background color I chose for the button.

[@nickvanoort9609]

I get the same, cannot find out how to get rid of it. Border is set to white...

[@ClaraGlocke-nk3qz]

Thank you so much for showing us how to do this. I have built the toggle and it changes some filters but not all. It also doesn't filter the tables. When I click on 'edit interactions' no symbols show anywhere. How do I ensure the toggle filters all visuals please?

[@garyb8930]

Bas, your videos are awesome and help me a lot every day, so I feel thankful to have found you 😁 Is this possible de set a size chart with toggle ? Like on OFF its 600 width and on ON it's 300 width ? The idea behind is to show 1 graph rougly full size of the page, and on toggle ON it's show 3 graphs so all 3 get smaller to fit on the page ?

[@mohamedaboobackersiddique7322]

Thank you, showing full screen will leads to small which may cause difficult in reading the exact content. Bas way of showing "focus method " is the best approach.

[@muhammetmuslu4429]

Very useful.You save my life.Thank you.

[@ghostgirl6970]

I always learn so much cool stuff from you! Thank you!

[@davidprovost3363]

Thank you for this brilliant light-weight idea ! I wonder how you could name navigator when you have multiple toggle buttons ?

[@pierre-loup7386]

Hello, thank you for these explanations. I use Power Bi and I have Toggle buttons. However, when I have filters, once I turn the toggle on or off, I have to redo my filter selection every time. Do you know if it is possible to leave the filters active while turning the toggle off and on? Thank you for your help.

[@osuravinuperera]

Super! Quick question, for some reason when I resize the button some sides of the padding doesnt work, specially the bottom and the left. Do I need to keep the size for a certain aspect?

[@rasmusl8370]

Just what I needed! I was close to this solution, but you closed the gap for me 👍

[@HowtoPowerBI]

nice 😎👊

[@nicolecodispoti1695]

This is great! How can you do this if you have multiple bookmarks? When I create a bookmark navigation, it pulls in all my bookmarks. Thank you!

[@shubhammore155]

Thank you for the guidance! However, when I attempted to apply it, I encountered an issue with formatting the symbol. Do you have any advice on how to resolve this?

[@namanmittal7791]

I create this image in Powerpoint first and pull them in PowerBI. But this one is really unique idea. I like it.

[@user-dl3jt9ce7w]

Great tip, thanks a lot! Bas, could you make a video about manage roles. It would be especially interesting to assign different roles to different report pages, change bookmarks by role, and other non-trivial tricks as you like)

[@nickreeve7052]

built-in limitations of PBI text padding make it impossible to get this down to the required size. However with character U+26AB, I can manage it (but this cannot change colour unfortunately). Thanks for another amazing vid!

[@Chemoa13]

Hello and thank you very much for this incredible tip ! I have a question, how do you manage to do another toggle button on another table of your report ? When I try to do another one it changes my first one.. Hope this is clear

[@matt5solomon]

Great video Bas, do you have a video that demonstrates how to combine visuals and make appear as one similar to the line charts in this video?

[@ukaszorzechowski5217]

Now i know that i ll be doing tomorrow at work! :D Great trick to throw out imported images

[@mrcrblr850]

menn you save me thank you very much this is exactly what i need it!!! Amazing Tutorial!

[@nseworld5521]

Ingenious as always 🔥

[@cornishlee]

Brilliant video, thank you Bas. One question though… I can’t resize the unichar for some reason? The number changes when I type it in but the symbol remains the same size?! Any ideas? Thank you.

[@benndii]

9 months later and I encounter the same problem... any solutions in the meantime, maybe?

[@unnikrishnansanthosh]

your ideas and creativity are out of the world ! thanks for sharing BAS

[@HowtoPowerBI]

so nice to hear!! thank you so much 😊

[@claudiozadorosny4722]

Amazing video, but I had problems with paddling. The bottom one just refused to work, so moving up the circle is looking impossible. Any solutions?

[@prozackpills]

Having the EXACT same problem no matter how I set the shape (pill or rectanglular with rounded edges) -- would love some help! 😖

[@karinaalmer3227]

Thank you for sharing. Have you also done a video in case you would like to add toggle buttons to other pages? Or does anyone from the comunity know how this could be done? it doesn't work with the same approach :) which seems to be obviously. Thank you!

[@theturkishviking-bushcraft]

This is AWESOME bro! Thanks!

[@nnnnfff]

Doesn't really work anymore. There's a weird outline of black around the Style > Border

[@sarveshdeshpande1772]

I liked the idea Bas , but I have used two images for on and off toggle that i created on powerpoint. Images seems to be much easier way. Your way is also awesome. Thanks for this video 😃👍

[@HowtoPowerBI]

Thx Sarvesh! 😊 if you dont care so much about having more objects / speed impact , then that approach also works great 👍

[@BluesFanUK_]

These tutorials are excellent, but it does highlight so many shortcomings in Power BI that could be very easily resolved by the developers.

[@HowtoPowerBI]

Thanks, agree… a lot of potential

[@user-xi7cj3so8f]

thank you for this ingenious solution!

[@gabrielmill3482]

It's working 🙂 thank you!

[@chriswade1833]

wow you are an artist!!!

[@analytics4uall]

Hii Bro, I'm Roshan from India. Your videos are useful, thanks for your tip and tricks\

[@arifbillah2563]

What a great and easy explanation, thanks for sharing..

[@leandrocampolim3812]

I love your channel, you helped me so much in my carrer. Thank you very for your content.

[@HowtoPowerBI]

Happy to hear this all the best to you!

[@HarshitKumarRai-cj4fg]

Thanks, buddy. You are great

[@meghakulshrestha4169]

So useful. Thanks so much!!

[@adamblake2466]

For anyone having resizing issues, try clicking the button and selecting an unselecting. This got my sizing to take.

[@DataAnalyst_ECP]

same here

[@juanignacioXI]

Always entertaining bas, keep it up!

[@piotrkuc8936]

@howtopowerbi Love the idea, thanks a lot for sharing! When I copy toggle button to new page, the original button stopped working. Any idea why?

[@infusionchurchmd]

Are we supposed to add the circle icon in the Toggle off area too? My circle icon seemed to disappear in the default state, but shows perfectly in the selected state.

[@gezin_longuevilleosaer4245]

Like all your video's: amazing!!

[@brianmullins8444]

Would it work different or break something if the Toggle OFF bookmark was also in the Toggle group?

[@spilledgraphics]

14 minutes well spent, danke Bas!

[@nicklea1988]

Something to be aware of is that not all Unicode characters are supported on Mac. So if you have users that will consume reports on a Mac then make sure you select a Unicode character supported on both Windows and Mac.

[@simonb7320]

Typical Mac and Apple being difficult.

[@katrinahernandez8201]

I thought you couldn’t use BI on a Mac?

[@nicklea1988]

@@katrinahernandez8201 You can't use Power BI to create reports, but you can consume reports.

[@nguyenminhthien3669]

I'm a newbie just starting to learn about Power BI, Do you have a list of Power BI tutorials for beginners? Thank you

[@emiljrgensen8371]

You could also just find or create blank button import a custom icon that you just download from a icon library, and then just use the "icon" option switch between two costom icons with selected and deffault state, abit easier.

[@Blomiley]

this was awesome!!

[@nishantkumar9570]

Awesome! Thank you so much

[@mrutyunjayapradhan3599]

Looks Gorgeous 😍

[@sanumpzha]

Well done Bas, nice content 👍

[@DendisTomas]

Hi, is there possibility how to make submetrics by some column? For example I have metrics for actual open claims total, but I want to see submetrics split by customer.

[@jejetator]

That is awesome Mate.

[@natsarev]

Another great tip! How do you come up with all of that?? 🤯😄

[@BenKetsa]

for some reason my border doesn't completely cover the fill color so a really thin outline appears. is there a fix to this?

[@meghanaraju264]

Amazing creativeness in simplifying designs ;)

[@travelkare]

Thanks buddy !

[@abubakrsaadmakyhoun7535]

Perfect as usual

[@user-jj8jb5ze6z]

Hi, i'd like a toggle that can be on several pages of the same report, which would be synchronized. Is this possible?

[@Woodborn]

There seems to be a bug in my version of Power BI (April 2024), the padding doesn't work to bring the circle up a little bit. Strange.

[@sohailansari9337]

Very creative work thanks for sharing.. Awesome👏👏

[@HowtoPowerBI]

Thanks Sohail 😊

[@niclaskammler1006]

Its great advise, but the dot doesn't change sice if i increase the font size :(

[@brunofernandeslopes8178]

Thank you very much!

[@wodraeve]

Awesome technique, only thing I am struggling with is that it is difficult to scale down, in other words if you want to have a small toggle button, the "dot" starts to be not center-aligned anymore...

[@sandipjabade1]

In Default stage if i am chaging the size of text, its not changing, but when i switch the mode from default to Selected its changing. Please advise

[@tamhtt1001]

Thanks for very helpful video. I like your voice😊