Team Performance vs. Target - with BOOKMARKS and TOGGLE

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

Bookmarking

pawel1
8 years ago
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?
pawel1
8 years ago
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

PaulDBrown

Community Champion

8 years ago

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

Kudo Kingpin

8 years ago

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
Community Champion
8 years ago

pawel1

Well! learn a new thing everyday!! Never "saw" that option!! Thank you!
PaulDBrown
Community Champion
8 years ago
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
  Kudo Kingpin
  8 years ago
  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
    Community Champion
    8 years ago
    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.