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.
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.
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.
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
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.
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
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.
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
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!
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.
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!
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 😃👍
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?
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.
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
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?
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.
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....
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.
I used to add two overlapping toggles images and now I am trying to follow your method. But it turns out the text size doesn't change when I re-size it. I just updated my desktop version. Any suggestion?
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...
The size of the circle doesn't change for me for some reason. Any ideas why that might be? I have the same unicode character as you, Bas. And I use Windows.
I fixed it somehow. Deleted the button and started all over and it's perfect now. One of PBI glitches, probably. I also noticed that the circle size changes when I change the size of the button.
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 ?
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.
Beautifully presented and very clear, BUT... I can't get it to work the way you demonstrated. It's fine up to 3:31 where the bookmark manager 'toggles between two states'. The two states invoke the correct bookmark filters, but the text on the button remains the same regardless of which way round I set the group, the bookmark and the deselection bookmark. By making the text of the main bookmark "Show / Hide Filters" I can deliver a usable solution because that text makes sense in both contexts but it is not as satisfying as your unicode trick. I tried it on multilple reports across different machines with different versions of PBI installed. Clearly I am missing a step, being remarkably stupid, or both. Either way I would LOVE some guidance here because your toggle switch is such an elegant and efficient solution (if only I could get it to work!
Hey! This might be outdated for you, but regarding your question: I recommend creating a new button and assigning new bookmarks to it. Copying and pasting a button will keep the original bookmarks, so the "copied" button will still navigate to the original visual or page. To avoid this, either create a new button and assign the bookmarks you want, or copy the button and manually update its bookmarks.
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!
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.
Deselect "Data": activate "Bookmarks" in "View", right-click on your bookmark, remove a hack from "Data". As a result, filters will not be removed by clicking on the toggle, all will be fine.
Hi Bas, after clicking on any slicer or datapoint, if we toggle the view, it again shows whole report rather it should the filtered report. How can it be achieved?
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! 👍😀
This is for bookmarks .. maybe check the last example of this video which shows an alternative toggle NEW Button Slicers in Power BI | 3 Examples You Don’t Want to Miss! ua-cam.com/video/czq-HRFQRnc/v-deo.html
Thank you, but I got a small issue: I see a border around the toggle, but it's not actually a border. It depends on the color of the "Fill"- so grey or green, and I cannot remove it. Would you have any idea how to get rid of it? Thank you very much again!
Thx for this high quality content! One question about additional tools, do u recommend to use software like Figma for dashboards design purposes or u think that power point is just enough?
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!
fr
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.
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
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.
9 months later and I encounter the same problem... any solutions in the meantime, maybe?
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.
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.
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
@@kovacsbarnabas2344 same happened for me
Why can't I resize ? I selected the font size exactly as you did but it doesn't resize in anyway
Same issue with me
Because the Borders are active by default. You need to switch borders off to resize the dot
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.
Typical Mac and Apple being difficult.
I thought you couldn’t use BI on a Mac?
@@katrinahernandez8201 You can't use Power BI to create reports, but you can consume reports.
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
that is a very neat and creative way to create toggle button without overlaying images. bravo!
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.
I get the same, cannot find out how to get rid of it. Border is set to white...
Did you guys find a solution to it
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
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!
awesome, glad to hear they help a bit. Thanks for watching and sharing ☺
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.
For anyone having resizing issues, try clicking the button and selecting an unselecting. This got my sizing to take.
is it possible to use toggle buttons for slicers too?
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?
Having the EXACT same problem no matter how I set the shape (pill or rectanglular with rounded edges) -- would love some help! 😖
Had the same problem .. did you find a solution to it please ?
Love the creativity behind this toggle button!
Thank you for watching Özkan! Yea was a lot of trial and error before i got it working with just 1 btn
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!
I always find it useful with your video, thanks for sharing
Very useful.You save my life.Thank you.
Bas I LOVE you. Have a fantastic 2023!
your ideas and creativity are out of the world ! thanks for sharing BAS
so nice to hear!! thank you so much 😊
I love these creative tips, it really takes the final report to another level and open mind to new ideas. Thanks for that, Bas.
How do we add text on off to the same please suggest something
These tutorials are excellent, but it does highlight so many shortcomings in Power BI that could be very easily resolved by the developers.
Thanks, agree… a lot of potential
Thanks for the spectacular training resources you give to us...
Thanks for the efforts in improving and adding values to others.
Glad to hear is was helpful! Thx 😊 Seyison
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 😃👍
Thx Sarvesh! 😊 if you dont care so much about having more objects / speed impact , then that approach also works great 👍
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?
I have the same problem especially for bottom padding, did you find a solution ?
I love your channel, you helped me so much in my carrer.
Thank you very for your content.
Happy to hear this all the best to you!
Hi, the text is not resizing and if I click on the button, it does not change his state. Some advices?
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.
This is AWESOME bro! Thanks!
Doesn't really work anymore. There's a weird outline of black around the Style > Border
Same for me + bottom padding option is not working
wow you are an artist!!!
I create this image in Powerpoint first and pull them in PowerBI. But this one is really unique idea. I like it.
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
14 minutes well spent, danke Bas!
Amazing creativeness in simplifying designs ;)
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?
Unable to increase the text size for the toggle
Great video, as always, clear, precise and fun to watch. Thank you!!
Thank you so much for making this video, I was searching this from so long.
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.
Love your creativity buddy. Much appreciated. cheers!
for some reason my border doesn't completely cover the fill color so a really thin outline appears. is there a fix to this?
Hello @BenKetsa! Did you manage to solve this issue? Thank you!
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....
Hello, My sincere thanks to you for the efforts you take to improve others and to add value to their lives.🙏.
Always excited to see the valuable content from you Bas!!!!
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.
I used to add two overlapping toggles images and now I am trying to follow your method. But it turns out the text size doesn't change when I re-size it. I just updated my desktop version. Any suggestion?
I have the same issue
Same issue
Did you find a solution to this?
@@jamespurcell3751 come on, it is 2024 already. ask AI and solve it in mins
bro, you are the best ! keep on sharing this kind of videos 👍
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.
you make things easy.. I used to keep 2 images and hope few other developer do so till now..
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...
menn you save me thank you very much this is exactly what i need it!!! Amazing Tutorial!
Excellent work Bas, you're just awesome.
thank you for this ingenious solution!
The size of the circle doesn't change for me for some reason. Any ideas why that might be? I have the same unicode character as you, Bas. And I use Windows.
same thing for me.
I fixed it somehow. Deleted the button and started all over and it's perfect now. One of PBI glitches, probably.
I also noticed that the circle size changes when I change the size of the button.
I am learning so much from you. Thanks for sharing your expert and creative knowledge of PBI ;)
Hi, i'd like a toggle that can be on several pages of the same report, which would be synchronized. Is this possible?
That's brilliant! I was used to create toggles using images, but this version is better
Thank you for this brilliant light-weight idea ! I wonder how you could name navigator when you have multiple toggle buttons ?
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.
Would it work different or break something if the Toggle OFF bookmark was also in the Toggle group?
Excellent
Looks Gorgeous 😍
@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?
I don't have the scale to fit option in my visual. What version are you using. I have the latest.
Just what I needed! I was close to this solution, but you closed the gap for me 👍
nice 😎👊
Hii Bro, I'm Roshan from India. Your videos are useful, thanks for your tip and tricks\
What a great and easy explanation, thanks for sharing..
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 ?
Superb, thank you
Nice result! The process to get there however feels quite cumbersome. Why can't that be just part of a standard UI?
yea i know, let's hope the power bi dev team got inspired 😄
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?
So useful. Thanks so much!!
hi, when i go to change the text settings with the default state (like size) in the style item, nothing changes. is it a bug? or is there another way?
I can’t believe its this hard to setup a simple toggle button in PBI. great tutorial btw
yeah, i whish it was easier as well .. till that day hope this vid helps a bit 🙂
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.
Beautifully presented and very clear, BUT... I can't get it to work the way you demonstrated. It's fine up to 3:31 where the bookmark manager 'toggles between two states'. The two states invoke the correct bookmark filters, but the text on the button remains the same regardless of which way round I set the group, the bookmark and the deselection bookmark.
By making the text of the main bookmark "Show / Hide Filters" I can deliver a usable solution because that text makes sense in both contexts but it is not as satisfying as your unicode trick. I tried it on multilple reports across different machines with different versions of PBI installed.
Clearly I am missing a step, being remarkably stupid, or both. Either way I would LOVE some guidance here because your toggle switch is such an elegant and efficient solution (if only I could get it to work!
I always learn so much cool stuff from you! Thank you!
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!
Hey! This might be outdated for you, but regarding your question: I recommend creating a new button and assigning new bookmarks to it. Copying and pasting a button will keep the original bookmarks, so the "copied" button will still navigate to the original visual or page. To avoid this, either create a new button and assign the bookmarks you want, or copy the button and manually update its bookmarks.
Hi Bas, what if there are too many bookmarks already? Thank you!
There is a new button slicer, you can now create it without bookmarks ua-cam.com/video/CYwzUjgI2TA/v-deo.htmlsi=FyrHWcRgSiqN1mAR
Now i know that i ll be doing tomorrow at work! :D Great trick to throw out imported images
Ingenious as always 🔥
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!
I'm a newbie just starting to learn about Power BI, Do you have a list of Power BI tutorials for beginners? Thank you
Can this toogle buttonbe used to switch between a Column Chart and a Line Chart? (Without using bookmarks, if that is something possible).
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.
Deselect "Data": activate "Bookmarks" in "View", right-click on your bookmark, remove a hack from "Data". As a result, filters will not be removed by clicking on the toggle, all will be fine.
Hi Bas, after clicking on any slicer or datapoint, if we toggle the view, it again shows whole report rather it should the filtered report. How can it be achieved?
make sure to update the bookmark correctly (you probably left the data state checked under bookmark options )
Yep, deselect "Data" :) right-click on your bookmarks - remove "v" from "Data
Very nice! Thank you.
You Sir are a Pro! However, wouldn't be easier to have a relevant button ready-made from Microsoft 🙂 ?
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! 👍😀
Excellent Excellent Excellent ❤❤❤❤❤❤❤❤ Lov you from Pakistan 🇵🇰
You're a genius, Bas. This helps a lot! Just one thing: How can I use the state of this toggle button in a measure?
This is for bookmarks .. maybe check the last example of this video which shows an alternative toggle NEW Button Slicers in Power BI | 3 Examples You Don’t Want to Miss!
ua-cam.com/video/czq-HRFQRnc/v-deo.html
@@HowtoPowerBI My bad, Bas, just after my posting I saw that you covered this in the video about the new slicer. Works like a charm. As usual 🙂.
Thank you, but I got a small issue: I see a border around the toggle, but it's not actually a border. It depends on the color of the "Fill"- so grey or green, and I cannot remove it. Would you have any idea how to get rid of it? Thank you very much again!
That is awesome Mate.
Great content usually I use two overlapping images. This one looks cool!!!
Thx for this high quality content! One question about additional tools, do u recommend to use software like Figma for dashboards design purposes or u think that power point is just enough?
F
I am unable to increase size of unicode character, using windows...pls suggest