Power BI Bookmarks, Selections and Toggles September 11, 2019 I’m gonna talk about the bookmark and selection pane on powerBI desktop that allows you to do some crazy stuff I am gonna talk about something that I learn insanely cool for one of my customers. All coming up. Tags:about, analytics, bookmark, Business Analytics, business intelligence, gonna, Guy in a Cube, GuyInACube, image toggle, Microsoft, Patrick LeBlanc, Power BI, Power BI Desktop, PowerBI, report, selection, Talk, toggle, visuals Related Posts Java tutorial: Using the Path class | lynda.com Lunch Atop A Skyscraper: The Story Behind The 1932 Photo | 100 Photos | TIME Building Successful Websites: Case Studies for Mature and Emerging Markets (Google I/O ’19) About The Author Glenn Jones 100 Comments darbzlul Does anyone knows if it's possible to do so , but with segmentation ?It would be like choosing the segmentation on one bookmark and showing the data on another one April 20, 2018 Reply Émerson Corlassoli Corrêa Really cool! Thanks Patrick! April 20, 2018 Reply Med Atef Mekkaoui Greaaaat you save my life with thal cool tuto 🙂 April 25, 2018 Reply Alan Jones I like the "slider" button here better than the ones I found on the free image sites I was looking at…. could you share? April 27, 2018 Reply sowmiya dayalan This works fine on PowerBI Desktop. How to make it work on a dashboard May 1, 2018 Reply supriya krish hey Patrick…Brilliant Trick 🙂 I am unable to use this as i don't find the link option in the format image.Any help on this 🙁 May 4, 2018 Reply Nelson Matias Great trick, but I wonder if it's possible to toggle on the connected user and not on a button. So let's say user A should see visual and user should see tables… is it possible? May 7, 2018 Reply Abdulaziz Al-Sharekh nice demo, i was trying to find a way to change bookmark based on filters. is there a way? May 9, 2018 Reply Brian Wormley Great video! May 12, 2018 Reply Carmen Gabriela Vazquez Ortega We would like a video about more sync slicer advanced options May 20, 2018 Reply Pranay Pawar This in insanely good bro.. Hats off to the creator.. Innovative one.. Cool May 20, 2018 Reply Flaming Infinity You just blew my mind apart, this is awesome!!! May 30, 2018 Reply Steve Camilleri Link is now replaced by Action. They should work pretty much the same no? June 1, 2018 Reply Noah Hadro I love the concept but I'm running into a challenge. Bookmarks change all the filters so if I have applied some filters and want those to remain the same… how can I toggle between charts like you do in the video but only have the button impact the two charts being hidden and revealed? Thanks for your help. great video. June 6, 2018 Reply Surendra Gudipati Hi Patrick, can we toggle Live Bookmarks as we are using live reports which requires dynamic data every time Or let me know any other solution to switch Visuals dynamically. June 7, 2018 Reply lucazarts25 Crazy awesome! Congrats and thanks bro! June 8, 2018 Reply JR For every word you speak, you have a hand movement, wow annoying, makes me dizzy, your older videos you just spoke, a hand movement here and there…. these newer videos, wow super annoying and hard to watch!! Check out your first 50 seconds…you even do a shoveling impression! Relax! June 8, 2018 Reply Jason Zhang Is there a way to sync slicers and have bookmarks on at the same time? I'm noticing that when I book mark a tab and select it through the image, my slicers do not transfer over. June 9, 2018 Reply Rasheed Siddiqui Hi, ur video is great !!! my concern is that I want the my Table should show and hide on click of data line in pie chart or graphs.Thanks in advance. June 13, 2018 Reply Ttf Web Tom- foolery—> bad-assery on this video. Great info! June 21, 2018 Reply Ajay Kumar When did will smith moved to IT? 😉 June 27, 2018 Reply justin sweet Great Video – love the explanations and demos, being new to this tool they are very helpful!!! This may have been asked/answered in one of the comments but I noticed that using the bookmarks it will always revert filters (i am using report level filter of year) to whatever was saved in the bookmark at that time. so if I saved the bookmark with a year filter of 2018, and on another page i set that report level filter to year 2017, if i click on the bookmark, it updates back to 2018. I guess bookmark is a snapshot of everything but is there way so that the bookmark will ignore the filters? June 29, 2018 Reply Darshil Mehta Hey Patrick, great video. Got a question. When you delete the page with title 'Tables', how does the dashboard retains the actual table the link from image to that table? Would you be able to share the .pbix file? July 3, 2018 Reply garima jain Can you please provide the link to the toggle button? July 9, 2018 Reply Jagannath Jayakumar Instead of a Image how I can use my slicer to do the same job July 11, 2018 Reply Nazimuddin Ar I just love all your videos July 23, 2018 Reply Ketan Patil Patrick – This is cool…thanks for the demo on this feature. July 26, 2018 Reply arun singh Can we create bookmarks through API? By applying filter and then create bookmark ? August 1, 2018 Reply Shanob Kottal Will this work if one of the reports is hidden? August 5, 2018 Reply Wilhelm van der Merwe Super video, as always – thanks Patrick. Have you ever experienced issues with toggles (the type you describe here) when copying visuals between reports (online)? I have noticed that there is no way (please share if there is) to copy bookmarks, so I ended up having to redo all those in Desktop, then publish again successfully, but… Now my report throws a "Something went wrong" when trying to save online… (Am I just getting the ID-10-T issue log, or am raging the machine?) August 10, 2018 Reply vijay rj hi patrick how can i get TOOGLE BUTTON August 13, 2018 Reply Xiaoxuan Xu This is a smart, but the problem of this toggle is you once you use it, the filter will go back to the value which was stored in the bookmark, making it not very useful. For example, I used DataStax in the filter when I add the bookmarks, now I change to Udemy (another company) and use the toggle to see the chart instead of table, suddenly it turned filter back to company DataStax, which is really bothering, anyone knows a way of working around this? August 14, 2018 Reply Martin Drenth Love it! August 14, 2018 Reply Rupak Rai hey its Rupak from India. is this same function working in power bi desktop because in my bi desktop there is no link option there is one action option. when i configure same in action its not working.can you please tell me something about action in format. August 16, 2018 Reply Daniel Alcaraz Hi Patrick, Many thanks for this video. It was really helpfull for me. My question is: How we can use the options "Display", "Data", "Select Visuals" that appear when you click on "three points" of every bookmark? Regards. August 22, 2018 Reply Julio Calleho Wow!!! Thank you, very helpfull August 25, 2018 Reply Gopi D I am not having "Link" option of image, i have only "Action". any one help how can i use the "link" option? September 4, 2018 Reply Eirik Hannisdal Ask Just used this to solve a problem at work. Brilliant September 5, 2018 Reply Gamers Glimpse Coooollllll…. good to see this idea.. will be using it tomorrow. September 11, 2018 Reply Echo Rosales Patrick i have a Power BI Pro. but i cannot find the LINK options on my image? i have a newer August update of BI. September 13, 2018 Reply LA REID SuperMAN Pat, that was great, but I don't see enabling Bookmarks, I guess everything works without turning on that option enabled 🙂 September 20, 2018 Reply Romil Khowal This video forced me to hit subscribed. Great Logic, Thanks September 28, 2018 Reply mahesh sharma Hi patrick , i am using power bi desktopsep version , i want to use bookmark to navigate few charts but it is not working . i am not able to locate enable option in file menu >> option >> preview settings however bookmark is showing under view option . when i am aligning chart as per bookmark then it automatically set default settings and cant navigate charts through buttons. please help me October 2, 2018 Reply Allison Gallagher Hi There! For some reason when I link one image to a specific bookmark and then go to link the other image, it auto changes the first image to the bookmark I am choosing for the 2nd image. Confusing.. basically I have two bookmarks and two images. Image 1 should be bookmarked to bookmark 1, when I change Image 2 to bookmark 2, Image 1 also changes to bookmark 2. October 12, 2018 Reply Chen J Such cool !!! October 23, 2018 Reply Darkhan 1 This is what i need October 30, 2018 Reply kranthi kumar Does hidden visuals have any performance impact? Will hidden visuals also get loaded on filter selections November 20, 2018 Reply Quinita Whitfield I don't see a link option when I click the image. Did something change in the more recent version of power BI November 20, 2018 Reply Wendy Tsai This is so great! Thank you so much! BTW you're so funny November 21, 2018 Reply Vatsal Makadia Great Video, But I'm unable to link to the image. Link option is not available under format image section. Any suggestion? November 21, 2018 Reply yazilimciningunlugu.com 1 – The latest version of PBI Desktop; there is no link at the format part instead u should use the action property. 2 – You should click the toggle image by using (Ctrl + Mouse Click). 3 – After you complete the bookmark working, do not forget to update all the things that you did on the page otherwise it will not work properly. 4 – For this demo; it is enough to create just one page, you should have confused to see more than one page at the beginning of the video. 5 – You can reach TOGGLE BUTTON .jpeg by google=>images easily. November 22, 2018 Reply Wm Gemmell This is awesome!!! November 22, 2018 Reply Ken Costigan Great job, you really helped me out! December 20, 2018 Reply denwo1982 How do you know what bookmarks are associated to which objects? And what objects are on a page? This can get some messy, is there no identifiers? December 31, 2018 Reply Cheryl Markus Hi, does this work with drill through? January 12, 2019 Reply Zied Rouatbi Hello, do you know why I don't see the link ander format image even when the imager is selected? January 17, 2019 Reply Chris Taulbee Just a tip, if you want to maintain your current slicer selections while you toggle between table/visuals (Or whatever your scenario is), then make sure to un-check the "Data" option when you right click on the bookmark in your bookmark pane. Otherwise, whatever slicer selections you have at the time you created the bookmark will be restored. January 22, 2019 Reply Phoebe Mo Patrick this is cool. What if i want this to apply on multiple pages? Can it be done? January 29, 2019 Reply Balakumar Moorthy Hi Patrick, how do we update the data's in the bookmark page. If I select today in the date filter and bookmarked the page and deployed in the report server. After some days the date filter will be inthe same date not in the current. How to get that. February 11, 2019 Reply Ulises Ciccola Hi Patrick. I have this problem. When i add another slicer to my report it appear in the page when i use the bookmarks. And eventhough i hide it with selection panel, when i click again in the bookmark it appear again.Thanks February 16, 2019 Reply JayP Singh Hello. First of all, really like your videos! Comprehensives and clear. I am been watching your videos on linking images to bookmarks and having trouble with something. I have 2 projects and have downloaded images and filtered the bookmarks using selection pane and then assigned actions to each of the images with the appropriate bookmarks. I made sure to "update" as well. Am I missing any step? When I click on the bookmarks, the actions work, but when I click on images, nothing happens. March 4, 2019 Reply Noel McGovern I can't find bookmarks on preview features? March 6, 2019 Reply brain stormer I have a doubt, are the images used in the bookmark subjected to copy right? Shall we use them legally? March 14, 2019 Reply Leandro Vieira Hey Guy, do you know something to switch pages automatically? For example, i will put it in a TV and i wanna change between page1 and page2 in an interval of 30 seconds. Thanks! March 30, 2019 Reply João Albino Thanks, man! It helped me a lot April 4, 2019 Reply khaoula BARHOUMI Hi , I have a question ! I am working on a report which contain 4 pages , what i want is when i select on the home page a buttom it goes automatically to that page : Meaning i have in a home page 3 numbers if i select number 1 it moves to page 1 .. what i did is that on each page i made a bookmark and on the home page i made a 3 buttoms and i did the link ! but it didnt work ! i need your help thanks April 5, 2019 Reply Edson Teixeira You great. Tks. Obrigado. April 16, 2019 Reply Dhruv Panchal great idea , but bad video . Try to make videos with more screen and less of your room April 22, 2019 Reply Dhruv Panchal seriously man , this is a nice idea but I can't really get what your saying , just make videos with more screen April 22, 2019 Reply Ranjit Ramakrishnan How do I print to PDF different bookmarks of a single page? April 29, 2019 Reply Kyle Ferguson This is really useful! Question- Is there a way to select a segment in one visualization then toggle to the other and it be pre-filtered from the selection is the first visualization? I figure I could create multiple bookmarks to do this for each selection, however that would potentially be too much to manage. May 3, 2019 Reply Darren Lsc Hi Patrick, instead using the picture i used button. When i hit the change view button the filter table seem to be mess up if i switch the view. Please advise. May 9, 2019 Reply Burhan Ahmed 👍 May 12, 2019 Reply Sam Tran Nice, just what my customer asked last week May 12, 2019 Reply Zulhisham Hashim new version of power bi dont have bookmark box to check, what should i do May 13, 2019 Reply Mark Ghanayem Great video! There is a situation where this will help a ton! May 18, 2019 Reply David Desboro I am trying to use bookmarks to hide and unhide selection slicers for a report. The slicers select Plant, Workcenter, and Shift. If I change the selection on the slicer and click the bookmark to hide the slicers, why does it revert back to the previous state? I am using the report as a desktop version as well as a presentation/plant visual. Thanks. May 25, 2019 Reply Ali Twaij excellent June 3, 2019 Reply Roberto Staltari Funny and clever! Thanks! June 4, 2019 Reply ab devillier Don't do comedy…how automatically move from one sheet to another just like power point slideshow June 6, 2019 Reply seanbunny2000 Opens up so many possibilities I hadn't considered before… Genius June 26, 2019 Reply Shebin Chacko So i wanted to create a view where if i select a button, i want it to remain highlighted while all other visuals in the report change dynamically. I used this approach that you showed me here (along with using an additional button [with a darker color indicating selection] and making it overlay over the first one, and ensuring the additional button with the darker color is picked up to show under the bookmark) and it works great. It shows beautifully. However, when i toggle between years in the slicer, it doesn't work 🙁 any suggestions or workarounds? June 26, 2019 Reply Debbie Edwards I've had some issues with this when the page with a toggle is got to from a drill through page, when I drill through, the target report shows the correct ID. When I click on the toggle, the ID changes. OR I click on the toggle and the ID remains the same. I then click on the toggle to go back and the ID Changes in the drill through. I seem to have got it working by setting Data to un-ticked for both bookmarks but I don't understand why. It seems wrong to me to not have data ticked on either bookmark. June 28, 2019 Reply Pramod Talisetti This is brilliant man! Thank you so much! June 30, 2019 Reply bHr¡G$ Hi Patrick.. I have added two toggle images as mentioned in yoir video but ctrl+click is not giving other image. Please help! July 1, 2019 Reply 2 weeks ago Brother looking like a snack. Can't even focus. July 7, 2019 Reply Pericles Rocha This helped me today. Thank you! July 10, 2019 Reply Vaibhav Singh how can we create a toggle just for one visual in our report? So that we can make separate toggle for all the existing visuals in the report? July 13, 2019 Reply Ravi N Subject: Dynamic change in chart(Not using Button. we must use Drop Down functionality) I have a requirement such as (If a single attribute is selected in Drop-Down it should display a Bar chart and if two attributes are selected in Drop Down the chart should change to scatter chart) in Power BI desktop app. Both these charts should be placed in the same place and it should change according to the user's selection. July 17, 2019 Reply Parikshith Gari Hi Patrick,Thanks for showing how the bookmarks work and linking it to an image. But I wonder how do I link a bookmark to a slicer instead? To be precise I have requirement when a certain company is picked from the slicer, that corresponding company's logo should appear on the dashboard. July 19, 2019 Reply Adarsh Chaubey Your so funny July 27, 2019 Reply oñaleM - What if there is a filter on a page, if i click the button link to bookmark, will it change the current filter i had? July 31, 2019 Reply Carlos Espinoza Excelent very detail August 1, 2019 Reply Prasad Dabbada Brilliant August 2, 2019 Reply Muhammad Ovais Jahanzaib one Disadvantage of bookmark when we switch between tabs its show old date data when we created a bookmark. August 17, 2019 Reply Harish Dhanarajan Thank you very much, it was a very helpful video. By the way, is there a way in PowerBI to implement Spin Boxes. Check out the link below, https://docs.microsoft.com/en-us/previous-versions/windows/desktop/bb246411(v=vs.85) August 21, 2019 Reply kumar Shourabh I recently got a question on bookmarks.. Is there a way that I can select a bookmark based on a selection in a dropdown? The business does not want me to create multiple buttons but, just select from a down down. Could you please help me here? August 21, 2019 Reply bobdim It is a very clever idea to deal with a big number of sheets, though I can not figure out how to make it work in phone view August 26, 2019 Reply Jai Kumar Daiya YOU DOING A GREAT JOB DUDE !!!!! KEEP IT UP !!!! August 30, 2019 Reply Nimai Ahluwalia Sir, It was not well explained step by step . September 11, 2019 Reply Add a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment Save my name, email, and website in this browser for the next time I comment.