Solved: KPI wrong value

javieezy · ‎05-12-2021

Hi im having a KPI problem here i've checked several posts but couldn't be able to solve my problems.

Objective: Shows YTD average of the KPI. The correct value should be:

But the I change it to KPI visual, it shows only the amount of the performance last week.

Seems like if no matter if its Month or by Week.

The data is from a Excel file, month looks like this, from month 1 - 5. Week number in the same way.

The problem should be: what should I put in Trend axis in order to show YTD value?

Appreciate your help!

HashamNiaz · ‎05-12-2021

Hi !

Seems like you are using KPI viusal. It has a problem, when you plot this against Date dimension or any member or Date Dimension it will show the Last Member Value of that element.

Meanining if you plot it against Months, So it will show the KPI value for the month which is been last in the current context.

To overcome this you can overlay 2 objects, 1 with Year so it will give you yearly YTD KPI value, and other with month to show monthly trend. For Yearly one you can turn off the trend axis, For Monthly one you can hide the KPI value.

View solution in original post

HashamNiaz · ‎05-12-2021

Hi !

Seems like you are using KPI viusal. It has a problem, when you plot this against Date dimension or any member or Date Dimension it will show the Last Member Value of that element.

Meanining if you plot it against Months, So it will show the KPI value for the month which is been last in the current context.

To overcome this you can overlay 2 objects, 1 with Year so it will give you yearly YTD KPI value, and other with month to show monthly trend. For Yearly one you can turn off the trend axis, For Monthly one you can hide the KPI value.