The BANANAS approach to use Power BI Bookmarks to swap tooltips

[@Greg0Connell]

This guy got $67 million in sales and still finds time to share his wisdom with us. That is so humble.🙂

[@zxsw85]

69 million dollar

[@uzigalko]

watching these gets me away from coding day by day. thanks!

[@MatthiasK-qp9bf]

1 is fancy, 0 is simple.... Digitalization explained at its best :-)

[@joaquinmaverick82]

Great video!! It will be great if using the slicer we can select diferents tooltips pages instead of hide/unhhide stuff in the tooltip page. Keep being awesome!! and thanks a lot for the trick

[@totvabe1]

Absolutely amazing!!! The best encourage to my work!

[@pukashell6170]

Really like this. So obvious when you see it demonstrated but I never thought of doing it this way. I was just working on a report with a disconnected table and slicer that toggled the data in the chart between two types of measures. Now I can use add a tooltip that changes as well. Totally Bananas!!

[@lucjanooo]

Thank you for this tip 💖

[@austinwilliams3599]

I had a similar use case this week, but i needed my tooltip to change based on whether a slicer option was checked or not. One no slicer checked -> run calc 1; if a slicer option is checked -> run calc 2. I placed two cards on top of each other and used conditional formatting to change one's text & background colors transparent if the other calculation was being run. Curious if your method would have worked for mine.

[@domenicforgione9059]

Hi, I have multiple buttons on my report that control various bookmarks. how do i get the name of the button that was clicked in my title... ie... "You selected [button] " and it updates when the other buttons are clicked? Thx.

[@demaxsuelmarques6382]

Thanks for your videos. It's so good.

[@garystocker4380]

Good guidance on bookmarks and actions

[@saseendrareddy1393]

I always amaze with your videos....! I have a question? let's say I have like 50 sellers. so, here I have a visual in that I indeed to show top 10 seller's data then, when I harrower my curser I need to see each seller image is it possible

[@kgsarma]

Thanks for the tip. I need a guide video to create the Fancy tooltips..like with images as shown in here..!!

[@pabeader1941]

Hey Alex!!

[@pabeader1941]

kzbin.info/www/bejne/i4O3cmqAj9h0qtk

[@yanny2000]

I'd like to give my user some Infos and explanations to each visual. Wouldn't it be useful if we could define for each visual specific, static text tooltip? Or is an easier way that I'm missing?

[@steverobinson8979]

Wouldn’t have it been easier to have two versions of the chart with each tooltip and toggle between them with a bookmark on the page. That way the format of the simple tool chart would have looked better?

[@thechillking2829]

Yes, that would be easier, but typically a chart is more resource intensive than two slicers. In the instance you propose, you duplicate the chart. That comes at a performance cost if you employ this technique often. Using the method shown in the video means you will not duplicate the main chart, just adding two slicers. This is better from a performance standpoint, though more work to set up.

[@thechillking2829]

Addition to my own comment: It appears you can replicate the functionality in this video with just your base chart, base tooltip and two bookmarks. Set up the bookmarks on the page with the tooltip. Have two bookmarks for your two states (or more, as many bookmarks as you have states). Uncheck current page (Absolutely necessary, prevents PBI from navigating to the page) and check selected visuals (good practice, but may not be needed depending on your use case). Have those bookmarks show/hide items in the tooltip to change the appearance. Now go back to the page with your base chart, and add buttons. Hook these buttons up to the bookmarks, and your changes will be reflected when you hover over the base chart.

[@mcnater]

FYI the sample link is broke.

[@AgulloBernat]

That was quite bananas! If the chart was a bar chart with categories, could you get different visual on the tooltip depending on the category?

[@hermesjrd]

Excellent tip You've gave us, Thank You

[@ShokatAliYT]

Can we just do this without the status table? Status table seems to be only used for formating the buttons. Can we just change hover/pressed properties in button formatting? Just curious.

[@NurmukhamedDuisenbayev]

how can I download the report? the link is not working

[@drummerboi4eva]

Awesome stuff !!!

[@cristian.angyal]

Great video. Thanks for sharing Adam!

[@jayantsharma3031]

Please do a video on Charticulator as well! Might as well do a series on it.

[@ameyraj4947]

This is very interesting will definitely include this in my report🎉

[@VladMZ]

Mind. Blown.

[@kevinbecker3436]

Hi Patrick, hi Adam You allways say that we could ask you questions and you maybe will answer them in a Video. I am searching for a bar chart with 2 y-axis. A costumer of us wants to see their Revenue and the percentage increase compared to last year in one visual How am I able to do that. When I drag both of these values in one visual the percentage bar is too smal compared too the revenue. woulb be nice if you have a solution for that.

[@arturocastillo3886]

Use 2nd axis

[@sanjeevnigam9265]

Amazing!!!

[@NartAbaza]

good one Adam 👍

[@chriswall4795]

Now .... where can I use that? 😀

[@tildemychristiansen8575]

So BANANAS! love it!

[@MrAszpic]

To change the TT page selection: Just make the buttons switch between 2 identical charts, each one linked to another TT page. Voila!

[@arya4it]

Neat 👍

[@musl1618]

👍👍👍

[@wmfexcel]

Banana! :)