The BANANAS approach to use Power BI Bookmarks to swap tooltips
HTML-код
- Опубликовано: 8 сен 2024
- Have you wanted to change the Power BI tooltips dynamically? This BANANAS trick allows you to at least switch the content of a report page tooltip to give you more flexibility and take your report to the next level!
Download Sample: guyinacu.be/swa...
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #Bookmarks #GuyInACube
This guy got $67 million in sales and still finds time to share his wisdom with us. That is so humble.🙂
69 million dollar
watching these gets me away from coding day by day. thanks!
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
1 is fancy, 0 is simple.... Digitalization explained at its best :-)
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!!
Absolutely amazing!!! The best encourage to my work!
Good guidance on bookmarks and actions
Thank you for this tip 💖
Thanks for the tip. I need a guide video to create the Fancy tooltips..like with images as shown in here..!!
Hey Alex!!
ruclips.net/video/URTA7JZsAtw/видео.html
Thanks for your videos. It's so good.
Excellent tip You've gave us, Thank You
Amazing!!!
This is very interesting will definitely include this in my report🎉
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
Mind. Blown.
Great video. Thanks for sharing Adam!
Please do a video on Charticulator as well! Might as well do a series on it.
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?
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.
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.
Awesome stuff !!!
Nice - i have a few ideas of how I'll use this.
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?
good one Adam 👍
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.
FYI the sample link is broke.
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?
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.
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.
So BANANAS! love it!
how can I download the report?
the link is not working
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.
Use 2nd axis
Neat 👍
To change the TT page selection: Just make the buttons switch between 2 identical charts, each one linked to another TT page. Voila!
Now .... where can I use that? 😀
👍👍👍
Banana! :)