Team Performance vs. Target - with BOOKMARKS and TOGGLE 06-22-2018 04:05 AM

[pawel1 · Accepted solution]

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 link

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

3. Setup Drillthrough option on Detail Page

4. rightclick Name to Drillthrough...

Filtered Detail Page opens

hope it helps

[DK23]

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?

[pawel1]

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

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

[DK23]

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.

[pawel1]

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

[DK23]

Sure i will. Thanks!

[kvdberg]

In what order did you update your bookmarks? When i update the bookmarks for the toggle function it automaticaly picks up the page level filters (which are for the bookmarks per salesperson)

[pawel1]

On top are bookmarks for the pages (individual sales reps), below bookmarks for the toggle (map/bar). 

But I think order is not important here.  Important is that you correctly set up the 'Data' filters for the two bookmark groups:

• Sales Reps - 'Data' filter is hacked
• Toggle (map/bar) - 'Data' filter is unhacked

hope it helps.

Pawel

excellab.at

[kvdberg]

Thanks a lot!