Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
06-15-2018 03:25 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. 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
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
Sure i will. Thanks!
I followed the creating bookmark but i don't see Title option in the Format Image box
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!
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?
great work pawel1! could you please share the dashbord?
Superb appearance and best dashboard.
Wonderful project looking quite good. I am a student practicing Power BI please do share .pbix file
This was actually, I am looking for. Please can you send me pbix file what you have prepared
Thank you
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!
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
hope it helps.
Hi Pawel,
I do not have the ""ACTION" option under "FORMAT IMAGE". Here is a screenshot:
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.
seems like you have an older version of PBI Desktop. check which version you have under Diagnostics:
File -> Options and Settings -> Options -> Diagnostics
if it's not April 2018 or later, you need to upgrade. only then you will enjoy the full power of the bookmark function.
Mine is September 2017 version. Thanks for highlighting that, will update.
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
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
Thank you so much for your prompt reply, I will check and let you know.
Regards
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
Hello, sorry to bother you again, I have been digging into this, and I have some replies form some MS Moderators, i.e "Your co-workers also require Power BI pro license to view the Power BI title."
Could you please let me know if you have a PRO license? and also if you have titles share into PowerAPP and someone else in your organization can see those titles?
Could you please confirm if PRO license is required? if not in that case I am doing something wrong because I can not get share my titles.
Thanks in advance for any advice,
Regards
yes I have PRO licence. share with me your dashboard to test.
Thank you for Sharing this , this is a quite good feature but was hidden , we need to enable the book mark in Option tab.
Appreciate your response on the same,
Regards
N Satish
Very nice look and feel,How did you made the first screen with navigation to certain page?
Regards
Satish