Team Performance vs. Target - with BOOKMARKS and TOGGLE 03-16-2022 07:07 AM - last edited 08-19-2025 08:50 AM

[pawel1]

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

[pawel1]

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' bookmark

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

[enghajer0]

Hi thank coud you please shared the pbix

[KevinMorneault]

HI How are you nice presentation, can you share the pbix file 

[ragygad]

can you please share the PBI file 
thank you so much 

[prateekjain5]

Looks great for performance monitoring

Wondering if you can please share the pbix file 

[prateekjain5]

Thanks Pawel

[aabbondanza]

Hi, this is wonderful.  Would you share the pbix file with me?  Lookng to learn about the bookmarking/toggling a bit more. 

thanks!

[tiffpiffpow2]

Wow - that toggle has blown my mind.  Can you please share with me ? 

[OneClick]

Hola. Podrías enviar tu ejemplo ?

muchas gracias

[KubasA47]

Great work and really addresses my need. Could you please share the pbix file 

[KubasA47]

Many thanks for the share and great report

[DigiManako1]

Thank you so much for providing the PBIX file of this Power BI Dashboard. I got the email reply within a few minutes. It is an amazing and informative dashboard. Thank you so much. Nishant Chandravanshi. 🙂  Best Wishes 

[Icad01]

Nice work 🙂

[Anonymous]

@pawel1

Great work!

Thanks for your help

ale

[Anonymous]

Can you send the pbix file?

[lorenabarbitta]

hello you can share it  thank you

[jhonnyflecha]

Great Job, this is an amazing report

[Anonymous]

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

[Anonymous]

Thanks a lot! 

[mike_123]

Would you like to share the .pbix files?

[pawel1]

for a .pbix file of this report please contact me here