KPI INdicator

[tmears]

Hi

i wonder if anyone can help or have a suggestion.  I have produiced a kpi Iindicator with the goals as as YTD Sales Target.  This is against a number of product items.  It works fine unless no monthly data is produced in the indicator column.  For example:

Product A

Month        Sales       Target

April          £5000      £5000

May          £5000      £5000

June          £0           £5000

the YTD goal in this instance will show £10000 as there are no sales in June, therfore 100%, however i would like it to show a gaol £15,000 and therfore 66% on the 1st of the month as this is when the new monthly target/goal is applied.

If i change the trend axis to show blank, i get (Blank) nan etc

Has anyone got any suggestions??

[v-yulgu-msft]

Hi @tmears,

According to current description, you want a KPI to show Target 15000 and Actual  10000, then calculate the percentage 66%, right? Do you want those values to be calculated dynamically depend on the date change?

Why did you remove the trend axis? In a KPI visual, trend axis section cannot be blank, otherwise, it will cause the visual blank.

Would you please share some sample data and elaborate your desired output with examples?

Regards,
Yuliana Gu

[vanessafvg]

@tmears

to create dummy rows i always do an if isblank, dont know if that will work but give it a bash

sales =
IF ( ISBLANK ( SUM ( table[sales] ) ), 0, SUM ( table[sales] ) )

[tmears]

thanks for the quick response, this is a direct query, so have to admit not sure how i would apply this?