Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
03-10-2022 08:00 AM
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. Identify 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
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?
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
Hi Could you please share .pbix file to my email honghanh85@gmail.com? I would love to learn more about bookmark and toggle. Yours is amazing. Thanks for sharing.
@pawel1 Great work with this. Can you share the PBIX file to my email (a_larranaga@hotmail.com) as is really what I'm need for 2022??
Hi thank coud you please shared the pbix
Hi thank coud you please shared the pbix
HI How are you nice presentation, can you share the pbix file to kevin.morneault@snb.ca
can you please share the PBI file with ragy.gadelkareem@gmail.com
thank you so much
Looks great for performance monitoring
Wondering if you can please share the pbix file to prateekjain5@outlook.com.au
Thanks Pawel
Hello, can you please send me the pbix file so I can get an idea. my mail id is shashankpetkar007@gmail.com
Can you please share the pbix file? This is perfect and exacctly what I am looking to use for our 2022 sales teams.
Edward.Cammarato@thermofisher.com Thank you!
Hi, this is wonderful. Would you share the pbix file with me? Lookng to learn about the bookmarking/toggling a bit more.
aabbondanza@singlesourceproperty.com
thanks!
Wow - that toggle has blown my mind. Can you please share with me ? tiffpiffpow@gmail.com
please share soumyasajith403@yahoo.com
Great work and really addresses my need. Could you please share the pbix file with alvaro.kubas@gmail.com
Many thanks for the share and great report
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
Can you please share the .pbix file? I asked but I never received it. Edward.Cammarato@thermofisher.com Thank you!
Nice work 🙂