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.
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
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.
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
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.
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
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.
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.
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 😃👍
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?
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 ?
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.
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!
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...
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.
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.
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 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?
Maybe the issue is in the "Data" field -> activate "Bookmarks" in "View", right-click on your bookmarks - remove "v" from "Data so that the toggle couldn't remove any filters by switching. I hope, it will solve/partly solve your problem.
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
Hey, maybe it's already not relevant for you, but as for your question - I would just create a new button with new bookmarks. Copying and pasting of the button takes the same bookmarks with it. So, since a bookmark navigates to another visual/page, your "new copied button" returns to the previous visual/page, too. So, either copy the button and assign new bookmarks, or create a new button.
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?
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.
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)
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.
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! th-cam.com/video/czq-HRFQRnc/w-d-xo.html
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?
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?
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....
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.
Very Nice. But how can I do it if I already have other bookmarks? Like I already have 2 bookmarks for other things, and I want to create this switch for new bookmarks.. When I insert the button, it shows me all 4 bookmarks.
Hi , Can you help me with my scenario. 1. I have added multiple 5 toggle button instead of 5 slicers. All 5 slicer is having yes or no value so i used toggle. 2. But case 1 :- each toggle is working independently. Case 2:- if user wants to apply 2 slicer then how it will work. Brother Please help me on this .
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! 👍😀
Hi, If Dates are in rows for example "B2 = Jan ......M2= Dec" and these columns having some amount. And in rows are some products. So how can we display in power BI month wise chart by clicking in slicer. Please help me out.
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
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?
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
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.
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
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
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.
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
that is a very neat and creative way to create toggle button without overlaying images. bravo!
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
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 ?
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.
is it possible to use toggle buttons for slicers too?
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 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.
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!
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
This is AWESOME bro! Thanks!
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 👍
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
I love these creative tips, it really takes the final report to another level and open mind to new ideas. Thanks for that, Bas.
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
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?
I always find it useful with your video, 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 ?
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 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!
your ideas and creativity are out of the world ! thanks for sharing BAS
so nice to hear!! thank you so much 😊
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?
Thank you for this brilliant light-weight idea ! I wonder how you could name navigator when you have multiple toggle buttons ?
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.
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!
For anyone having resizing issues, try clicking the button and selecting an unselecting. This got my sizing to take.
Bas I LOVE you. Have a fantastic 2023!
you make things easy.. I used to keep 2 images and hope few other developer do so till now..
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.
@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?
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!
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.
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...
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.
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.
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
Would it work different or break something if the Toggle OFF bookmark was also in the Toggle group?
Hi, i'd like a toggle that can be on several pages of the same report, which would be synchronized. Is this possible?
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?
Maybe the issue is in the "Data" field -> activate "Bookmarks" in "View", right-click on your bookmarks - remove "v" from "Data so that the toggle couldn't remove any filters by switching. I hope, it will solve/partly solve your problem.
@@ektcm Thank you. I will go and try that out!. 🙂
Great video, as always, clear, precise and fun to watch. 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
How do we add text on off to the same please suggest something
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
Hey, maybe it's already not relevant for you, but as for your question - I would just create a new button with new bookmarks. Copying and pasting of the button takes the same bookmarks with it. So, since a bookmark navigates to another visual/page, your "new copied button" returns to the previous visual/page, too. So, either copy the button and assign new bookmarks, or create a new button.
14 minutes well spent, danke Bas!
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
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 😄
Very useful.You save my life.Thank you.
Hello, My sincere thanks to you for the efforts you take to improve others and to add value to their lives.🙏.
Hi BAS, thanks for the video. However I am not able to resize the text/icon. is it a problem with Power BI update ? do you have any solution ?
I have the same problem
I don't have the scale to fit option in my visual. What version are you using. I have the latest.
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 ;)
I create this image in Powerpoint first and pull them in PowerBI. But this one is really unique idea. I like it.
Thank you so much for making this video, I was searching this from so long.
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)
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 th-cam.com/video/CYwzUjgI2TA/w-d-xo.htmlsi=FyrHWcRgSiqN1mAR
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.
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?
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!
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!
th-cam.com/video/czq-HRFQRnc/w-d-xo.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 🙂.
Hii Bro, I'm Roshan from India. Your videos are useful, thanks for your tip and tricks\
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
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.
Can this toogle buttonbe used to switch between a Column Chart and a Line Chart? (Without using bookmarks, if that is something possible).
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.
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!
menn you save me thank you very much this is exactly what i need it!!! Amazing Tutorial!
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
Always excited to see the valuable content from you Bas!!!!
Dude! I use 2020 version in my organization. I do not have option for Bookmark Navigator.What should I do?
Run to a different company 😂😅🏃♀️🏃
@@HowtoPowerBI 🤣🤣🤣🤣
Another great tip! How do you come up with all of that?? 🤯😄
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....
Hi, the text is not resizing and if I click on the button, it does not change his state. Some advices?
Love your creativity buddy. Much appreciated. cheers!
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.
Just what I needed! I was close to this solution, but you closed the gap for me 👍
nice 😎👊
Very Nice. But how can I do it if I already have other bookmarks? Like I already have 2 bookmarks for other things, and I want to create this switch for new bookmarks.. When I insert the button, it shows me all 4 bookmarks.
With the bookmark group he showed it works
From 2:08
Amazing creativeness in simplifying designs ;)
Hi ,
Can you help me with my scenario.
1. I have added multiple 5 toggle button instead of 5 slicers. All 5 slicer is having yes or no value so i used toggle.
2. But case 1 :- each toggle is working independently.
Case 2:- if user wants to apply 2 slicer then how it will work.
Brother Please help me on this .
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! 👍😀
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
Hi, If Dates are in rows for example "B2 = Jan ......M2= Dec" and these columns having some amount. And in rows are some products. So how can we display in power BI month wise chart by clicking in slicer. Please help me out.
unpivot the month columns in power query so that you have a 1 column for month, 1 for product, 1 for values
@@HowtoPowerBI Thank you so much, please permit me if i can ask more doubts.
how can we keep filtering?(data is unchecked, if i select value in a table and toggle to a bar chart, filters are removed)
wow you are an artist!!!
😲🤯 Simply a---MAZING!! Thanks again for the awesome tip, Bas! 🙏 Time to go update a bunch of my old reports with layered toggles! 😑
You Sir are a Pro! However, wouldn't be easier to have a relevant button ready-made from Microsoft 🙂 ?
I am unable to increase size of unicode character, using windows...pls suggest
That's brilliant! I was used to create toggles using images, but this version is better
What a great and easy explanation, thanks for sharing..
Looks Gorgeous 😍
How do I create a questionaire with toggle switches for imputting the answers?