How To Add Target for KPI Visual ?

[melhajj]

Greetings All,

I want to use the KPI Visual to display the yearly ratio of Local Employment

I have created a measure which works perfectly fine. My measure is

LocalEmploymentRatio= ([TotalLocalHeadCount]/[TotalHeadCount]) * 100 (the result is a percentrage since I multiplied by 100)

Now I want to plot this measure on a KPI visual and compare it to a target on a yearly basis : I do not have target values coming from the database however I can enter the target values as  provided to me by the business user in a table for each year , for e.g. :

Year.    Target

2017.    50%

2018.    45%

2019.    47.5 %

I joined the above table with my Date Dimension table on the Year column which is used in a slicer , however whatever year i choose the value is always showing green i.e. I have achieved the target  , for eg for year 2017 my measure is equal to 48 % (below target) but it is showing as green.

I am suspsecting the issue is in the way I have entered the Target in the table but whatever I try it does not work. Any guidance would be appreciated.

Regards

[amitchandak · Accepted solution]

@melhajj ,

You should create a date like this and join with date table

date = date([Year],12,31)

While last date for target , refer this video

https://www.youtube.com/watch?v=yPQ9UV37LOU&t=39s

[Anonymous · Accepted solution]

Hi...  Have you checked to make sure that you are calculating your percentages the same way?  You may be displaying the target value as 50%, but the calculation is actually 0.50...  Your measure is multiplying by 100 in your calculation, so 50.00.  Try by removing the "*100" from your measure and see what happens.

This may be why you are getting everything showing green.

Lou

[amitchandak · Accepted solution]

@melhajj ,

You should create a date like this and join with date table

date = date([Year],12,31)

While last date for target , refer this video

https://www.youtube.com/watch?v=yPQ9UV37LOU&t=39s