KPI Visual showing Blank when target is added

[TorbenM]

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 formular to "calculate a fixed target":

value 0.97 = 0,97

I want to use these two Measures in a KPI Visual but get Blank as result. The interesting thing is, that if I switch aroung "indicator" and "target goal" I get a number. But of course the number is wrong for my purpose.

Also when I just add the indicator without the target I get a number back. Only when I combine the two fields  in one certain way I get Blank.

I have no clue what causes this behaviour. I would at least have expected that it shows BLANK in both cases. Here is a picture that explains the problem:

Thanks in advance for your help.

BR,

Torben

[BSacchini]

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

[TeigeGao · Accepted solution]

Hi @TorbenM ,

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

[varamati]

@TeigeGao ,

In the example specified, I want to have a dynamic goal i.e median(column1). How can I specify goal here?

If I create a calculated measure for the median to fix this, it is rendering blank.

Thanks in advance,

Veda