How to create targets responsive of a period of time

[condolar]

Hey guys,

I am trying to create a KPI style dashboard and I have targets for individuals, which adjust dependant of the number of indivudals selected. However I really need to link a period of time to the targets, as currently they are fixed. I have to create multiple dashboards for the time period i.e. daily, weekly, monthly.

I have a date selector on my dashboard and I need the targets to adjust according to the time period selected. Any ideas on how best to acheive this?

Thanks in advance!

[condolar]

@amitchandakI currently have them as weekly, howver this is obviously very easily adjusted. If you would reccommend to use yearly?

I also have targets for multiple users and for multiple measures of work, would you reccomend making a seperate table for each measure? (For example I have targets for; Calls, Notebook Entries, CV Sends, Interviews Booked, Billings. Some of these targets also vary from person to person)

[amitchandak]

@condolar , at what level is your target as now? Assume they are at year level

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...