skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led Training
      • Overview
      • Guided learning
      • Documentation
      • Webinars
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Galleries
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • MBAS Gallery
    • MBAS Gallery 2020
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Re: Team Performance vs. Target - with BOOKMARKS a...
    Accepted Solution

    Re: Team Performance vs. Target - with BOOKMARKS and TOGGLE

    06-22-2018 04:05 AM

    pawel1
    Continued Contributor
    27256 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Team Performance vs. Target - with BOOKMARKS and TOGGLE

    ‎12-17-2017 06:58 PM

    Are we going to reach the TARGET and receive our bonuses for 2017? 

     

    With the year-end approaching, I want to share with my team on a daily basis, how we are scoring against the target, where we can still push, which customer? which product?  The target (and bonuses) are within reach!

     

    This Power BI report uses bookmarks and drillthrough to better organize the content, to move fluently between pages, to switch between visuals (toggle) and to drill down Sales Reps, Customers and Products.

     

    Analysis steps:

    - Click on a team member photo to open his/her Sales Rep Bookmark. Switch visuals using TOGGLESwitch visuals using TOGGLEIdentify negative (red) customers.

    - Switch between Map and Bar visuals using the Toggle image

    - Drillthrough customer (right click on the bar chart) to open Customer Bookmark

    - Identify Product opportunities within customer, switch between Scatter and Matrix visuals using Toggle

    - On slicer, select UNITS or PROFIT, select PERIOD to understand long and short term trends.

     

    Refreshed daily.

     

     

     

    eyJrIjoiMjRkYjM1NjEtMTc0Zi00MzcyLTliZjgtYjU0YWJiMjQ3OTg5IiwidCI6ImI3M2IxZDZlLTIxZDUtNGUzOC1iMjM5LTgxMzRkOWQyYmY3OCIsImMiOjh9

    Preview file
    123 KB
    Labels:
    • Labels:
    • Bookmarking
    Message 1 of 55
    44,795 Views
    56
    Reply
    2 ACCEPTED SOLUTIONS
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-21-2018 12:55 AM

    you mean Link option?  You will find the Link option under FORMAT IMAGE - ACTION.  

    In the below example:

    1. click 'Biondi' picture

    2. select Format Image - Action - Bookmark / Biondi to link 'Biondi' picture to 'Biondi' bookmarkbiondi.PNG

     

     

    hope it helps.  or is your questions really about Title option?

    Message 27 of 55
    28,500 Views
    2
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-22-2018 04:05 AM

    Alternatively to Bookmark you can use DRILLTHROUGH.  similar result but faster, you only need to remember to rightclick instead of click.  the way I do it:

    1. import a table with Names + URL Image linkdrillthrough URL.png

    2. Create Front Page (with names + URL) and Detail Page 

    3. Setup Drillthrough option on Detail Pagedrillthrough setup.PNG

    4. rightclick Name to Drillthrough...drillthrough from.PNG

     

     

    Filtered Detail Page opensdrillthrough detail page.PNG

    hope it helps

    Message 29 of 55
    27,256 Views
    1
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    JP_is_BI
    JP_is_BI
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎02-20-2018 03:40 PM

    This is one of the most customized and well finished reports I have seen. The toggle is an amazingly innovative idea. 

     

    Congratulations on your creation!

     

    Message 35 of 55
    2,495 Views
    0
    Reply
    Krishnamurthy
    Krishnamurthy
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-30-2018 04:41 AM

    Impressive visualization. Can you please let us know the steps taken for desigining the opening page where when we click on images it is taking to the respective pages

    Message 11 of 55
    38,122 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Krishnamurthy
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎01-30-2018 06:13 AM

    Glad you like it.  The 5 images on the front page are simply linked to respective 5 BOOKMARKS. 

    1. Once you have your Main Page (with KPI's for a single sales rep) working, clone it by creating bookmarks for each sales rep. In the Bookmarks Pane (View --> Bookmarks Pane) you should see 5 bookmarks named after sales reps
    2. On the Front (Selection) Page, INSERT IMAGES (Home -->Image) of the 5 sales reps
    3. LINK each image to a respective Bookmark (Format Image -->Link -->Bookmark)

    insertimage.pngDone. Use Ctrl+Mouse to see report for a selected sales rep.

    Message 12 of 55
    2,641 Views
    3
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-22-2018 01:40 AM

    I have a question and a situation at the same time. In your dashboard you have limited user but if i have a team of 20-25 people, do I have to create those number of bookmarks?

     

    Is there a way to use images as Slicer without creating bookmarks for every individual?

    Message 28 of 55
    2,031 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-22-2018 04:05 AM

    Alternatively to Bookmark you can use DRILLTHROUGH.  similar result but faster, you only need to remember to rightclick instead of click.  the way I do it:

    1. import a table with Names + URL Image linkdrillthrough URL.png

    2. Create Front Page (with names + URL) and Detail Page 

    3. Setup Drillthrough option on Detail Pagedrillthrough setup.PNG

    4. rightclick Name to Drillthrough...drillthrough from.PNG

     

     

    Filtered Detail Page opensdrillthrough detail page.PNG

    hope it helps

    Message 29 of 55
    27,257 Views
    1
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-26-2018 01:24 AM

    This looks great but i have a simple question i have individuals pictures on my local drive can i give the path instead of web based link? Or does it have to be a URL only?

    Message 30 of 55
    1,754 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-26-2018 02:15 AM

    you can link inserted image to bookmark.  insert image - format image - action - bookmarkimage link to bookmark.PNG

     however, you cannot conect to your local drive path to get the images.  it works with URL only, as far as i know.

    Message 31 of 55
    1,751 Views
    0
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-26-2018 03:19 AM

    As mentioned earlier i have a team of 50 team members and creating 50 bookmarks will be a real tidious job, hence, Drillthrough sounded a better option but if this is a challenge then i guess will have to try something else.

     

    If I have the image on OneDrive or Google Drive will that work? Because i'm not sure how will i link individuals images through URL as this will be a real time & interactive dashboard.

    Message 32 of 55
    1,748 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-21-2018 05:04 AM

    Contact me here if you want to get a .pbix of this report

    Message 33 of 55
    1,529 Views
    1
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎12-13-2018 12:24 AM

    Sure i will. Thanks!

    Message 34 of 55
    1,425 Views
    0
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-20-2018 11:30 PM

    I followed the creating bookmark but i don't see Title option in the Format Image boxPBI3.PNG

    PBI4.PNG

    also, i'm using the latest version of PBI [2.59.5135.601 64-bit (June 2018)]. Is there another way of doing it. I'm trying to create the same visual effect what you have in your dashboard. It'll be great if you have created any tutorial on how to do this step by step, kindly do share if you have any.

     

    Thanks!

     

     

     

    Message 26 of 55
    2,050 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-21-2018 12:55 AM

    you mean Link option?  You will find the Link option under FORMAT IMAGE - ACTION.  

    In the below example:

    1. click 'Biondi' picture

    2. select Format Image - Action - Bookmark / Biondi to link 'Biondi' picture to 'Biondi' bookmarkbiondi.PNG

     

     

    hope it helps.  or is your questions really about Title option?

    Message 27 of 55
    28,501 Views
    2
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-15-2018 03:25 AM

    Somehow the feature to enable Bookmark is not available in the latest version of PBI Desktop. Is there a workarund for this as i'm trying to create similar visualization?

     

    Any help would be really appreciated!

    Message 21 of 55
    2,106 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-16-2018 09:31 AM

    indeed, the place to enable bookmark (by clicking on a picture) has changed.  It's no longer under 'LINK' but under 'ACTION'  and you find it in the FORMAT IMAGE pane

    bookmark action.PNG

     hope it helps.

     

    Message 22 of 55
    2,099 Views
    0
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-18-2018 06:57 AM

    Hi Pawel,

     

    I do not have the ""ACTION" option under "FORMAT IMAGE". Here is a screenshot:PBI.PNG

    Let me know if I'm missing something here. As i have checked in the "OPTIONS" > PREVIEW FEATURES every box is checked except Spanish language. As i'm unable to enable "Bookmark Pane" under View.

     

     PBI2.PNG

     

    Message 23 of 55
    2,084 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-18-2018 07:50 AM

    seems like you have an older version of PBI Desktop.  check which version you have under Diagnostics: 

      File -> Options and Settings -> Options -> Diagnostics PBI desktop version.PNG

     if it's not April 2018 or later, you need to upgrade.  only then you will enjoy the full power of the bookmark function.

     

     

    Message 24 of 55
    2,081 Views
    1
    Reply
    Anonymous
    Not applicable
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-18-2018 11:19 PM

    Mine is September 2017 version. Thanks for highlighting that, will update.

    Message 25 of 55
    2,075 Views
    0
    Reply
    sajarac
    sajarac Helper III
    Helper III
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-06-2018 10:51 AM

    Hi there, firts at all, this is the most powerfull presentation so far for the PowerBI, I am new here, and I just create my first one and I have a question that maybe you faced before and can provide some advice.

     

    I have my PowerAPP with some PowerBI titles added, for me works great, but for the other users, the users that have access to my PowerAPP they cannot see the titles, any idea what is the issue?

     

    Thanks in advance

    Preview file
    13 KB
    Message 14 of 55
    2,181 Views
    0
    Reply
    pawel1
    pawel1 Continued Contributor
    Continued Contributor
    In response to sajarac
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-07-2018 02:15 PM

    happy to hear you like my report. 

    regarding the issue "The report shown in this title doesn't exist or you don't have permission to view it" , please refer to the discussion in this forum.  Two ideas: 

    "...create a new public working group"

    "...after an hour or so the problem is fixed by itself" 🙂

    hope it helps 

    Message 15 of 55
    2,169 Views
    0
    Reply
    sajarac
    sajarac Helper III
    Helper III
    In response to pawel1
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-07-2018 02:44 PM

    Thank you so much for your prompt reply, I will check and let you know.

     

    Regards

    Message 16 of 55
    2,162 Views
    0
    Reply
    sajarac
    sajarac Helper III
    Helper III
    In response to sajarac
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-07-2018 03:26 PM

    Hi, I have readed the post and in fact they say that creating a public group to share the reports will fix the issue.

     

    Sorry to bother you I am new in PowerBI and I have no clue on how to do it, could you please point me in the right direction?

     

    Thanks again

    Message 17 of 55
    2,156 Views
    0
    Reply
    Preview Exit Preview

    never-displayed

    You must be signed in to add attachments

    never-displayed

    Additional options
    You do not have permission to remove this product association.
     

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    • © 2021 Microsoft
    • Follow Power BI
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks