Team Performance vs. Target - with BOOKMARKS and TOGGLE 12-17-2017 18:58 PM - last edited 01-07-2020 11:29 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?

[VV13]

Can you send the pbix file?

[lorenabarbitta]

hola puedes compartirlo al correo de lobar28@hotmail.com gracias

[jhonnyflecha]

Great Job, this is an amazing report

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

[mike_123]

Would you like to share the .pbix files?

[pawel1]

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

[mpfarhat]

Thanks for sharing this excellent example!

How did you create the KPI?  Which visual(s) are you using to compose the KPI (Title, Value, Indicator Symbol)?

Thanks for any insight you can share.

--Michael--

[pawel1]

I used the standard Card visual for both KPI and Arrow, and a Chicklet Slicer for the Unit/Profit Selection.

To get the arrow-up (green) / arrow down (red) symbols I used UNICHAR and colored Data Labels green (128315 is by default red). 

here are the measures:

 hope it helps

[Anonymous]

This was of great help as i was struggling get this right. 

[mpfarhat]

Fantastic!  Thanks so much!

This really is an excellent report!

--Michael--

[nick9000]

This is a great report, how did you create the legend for above and below target for the map visual?

[pawel1]

no rocket science here.  the legend is simply a picture that I created in Power Point, saved as .png and imported into PBI 

[PaulDBrown]

@pawel1

Fantastic report! I have a question if I may. How do you get to display the selective labels in the cumulative chart? Do you create separate measures for each (MAX or whatever) and add them as values?

Thanks for your help,

Regards,

Paul.

[pawel1]

Hi Paul,

glad you like the report. 

you can control density of labels in a line chart by adjusting the 'Label density' (Format - Data Labels - Label density)

 

 no need to create separate measures unless you need to highlight specific dates. 

hope it helps, 

Pawel 

[PaulDBrown]

@pawel1

Is the Line graph the Power KPI custom visual by any chance? The default Line Chart Visual in Power BI Desktop (April 2018 version) is lacking the "label density" option. 

[pawel1]

yes, the 'label density' is a feature of the standard Line Chart.

if you don't see it, try this: adjust your Axis to 'DateID' (day) instead of 'Date Hierarchy'. 

[PaulDBrown]

@pawel1

Thanks for that. Therein lies my "problem": I'm using a non-standard date table (Month granularity) so I assume that's why the option isn't available. The funny thing is the Power KPI visual does have it as an option for this particular graph, so I may just change it to that visual.

Thanks again for your help!

Regards,

Paul.

[PaulDBrown]

@pawel1

Well! learn a new thing everyday!! Never "saw" that option!! Thank you!