The BANANAS approach to use Power BI Bookmarks to swap tooltips

Ғылым және технология

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/swaptooltipsample
📢 Become a member: guyinacu.be/membership
*******************
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/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #Bookmarks #GuyInACube

Пікірлер: 42

  • @Greg0Connell
    @Greg0Connell3 жыл бұрын

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

  • @zxsw85

    @zxsw85

    3 жыл бұрын

    69 million dollar

  • @pukashell6170
    @pukashell61703 жыл бұрын

    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!!

  • @totvabe1
    @totvabe13 жыл бұрын

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

  • @hermesjrd
    @hermesjrd3 жыл бұрын

    Excellent tip You've gave us, Thank You

  • @lucjanooo
    @lucjanooo3 жыл бұрын

    Thank you for this tip 💖

  • @joaquinmaverick82
    @joaquinmaverick823 жыл бұрын

    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

  • @demaxsuelmarques6382
    @demaxsuelmarques63822 жыл бұрын

    Thanks for your videos. It's so good.

  • @cristian.angyal
    @cristian.angyal3 жыл бұрын

    Great video. Thanks for sharing Adam!

  • @garystocker4380
    @garystocker43803 жыл бұрын

    Good guidance on bookmarks and actions

  • @ameyraj4947
    @ameyraj49473 жыл бұрын

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

  • @drummerboi4eva
    @drummerboi4eva2 жыл бұрын

    Awesome stuff !!!

  • @uzigalko
    @uzigalko3 жыл бұрын

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

  • @MatthiasK-qp9bf
    @MatthiasK-qp9bf3 жыл бұрын

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

  • @sanjeevnigam9265
    @sanjeevnigam92652 жыл бұрын

    Amazing!!!

  • @austinwilliams3599
    @austinwilliams35993 жыл бұрын

    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.

  • @VladMZ
    @VladMZ3 жыл бұрын

    Mind. Blown.

  • @Crazy5exycurvy
    @Crazy5exycurvy3 жыл бұрын

    Nice - i have a few ideas of how I'll use this.

  • @NartAbaza
    @NartAbaza3 жыл бұрын

    good one Adam 👍

  • @AgulloBernat
    @AgulloBernat3 жыл бұрын

    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?

  • @jayantsharma3031
    @jayantsharma30313 жыл бұрын

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

  • @yanny2000
    @yanny20003 жыл бұрын

    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?

  • @kgsarma
    @kgsarma3 жыл бұрын

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

  • @pabeader1941

    @pabeader1941

    3 жыл бұрын

    Hey Alex!!

  • @pabeader1941

    @pabeader1941

    3 жыл бұрын

    kzread.info/dash/bejne/h4aIo5mDitanpNo.html

  • @domenicforgione9059
    @domenicforgione90593 жыл бұрын

    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.

  • @saseendrareddy1393
    @saseendrareddy13932 жыл бұрын

    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

  • @ShokatAliYT
    @ShokatAliYT2 жыл бұрын

    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.

  • @arya4it
    @arya4it3 жыл бұрын

    Neat 👍

  • @steverobinson8979
    @steverobinson89793 жыл бұрын

    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

    @thechillking2829

    2 жыл бұрын

    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

    @thechillking2829

    2 жыл бұрын

    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.

  • @user-rd3wq8gf7q
    @user-rd3wq8gf7q2 жыл бұрын

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

  • @mcnater
    @mcnater3 жыл бұрын

    FYI the sample link is broke.

  • @tildemychristiansen8575
    @tildemychristiansen85753 жыл бұрын

    So BANANAS! love it!

  • @kevinbecker3436
    @kevinbecker34363 жыл бұрын

    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

    @arturocastillo3886

    2 жыл бұрын

    Use 2nd axis

  • @chriswall4795
    @chriswall47953 жыл бұрын

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

  • @musl1618
    @musl16182 жыл бұрын

    👍👍👍

  • @wmfexcel
    @wmfexcel3 жыл бұрын

    Banana! :)

  • @MrAszpic
    @MrAszpic3 жыл бұрын

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

Келесі