Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

KPI Visual showing Blank when target is added

Hi,    I have come across a strange behaviour of the KPI-Visual that I seem not be able to solve:   I Have two measures. One of them calculates some percentage the other one just uses a simple fo...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Anonymous ,

    Please refer to the following example:

    Assume that I have a table like below:

    Then I create a measure as the target like below:

    value = 205

    Then drag these columns to the related field, the result like below:

    Best Regards,

    Teige

BSacchini's avatar
BSacchini
Frequent Visitor
7 years ago

Hello. I am having the same problem.

 

I know why it is happening although I havent been able find a way around the issue.

 

I created two measures: 1) A measure I want to track using KPI and 2) A "fixed" measure that indicates the treshold for my KPI goal (e.g: 10). 

When I create my KPI I want it to have a trend axis (date hierarchy by months). 

 

So basically the problem is that my first measure (the one I am looking to track) comes from a table that is up to the maxcurrentdate, while the second measure (the fixed goal) comes from a table that is populated for the entire year (see picture). So logically the KPI will analyze the last given month, which has a Fixed Goal but has no value for the measure that I want to track, hence I get the BLANK result.

 

How do I set my Goal Measure to only provide values for current or past months?

 

Thanks