Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

KPI visual without trend

Hi!   I am looking for a KPI visual where I can show my KPI versus target WITHOUT a trend. My target is on my total number.    Is that possible?
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    KPI visual would display blank without adding any field into "Trend axis". As a workaround, to set total number as target value in KPI, you could create a measure similar to below, add it into "Target goals":

    total target = SUMX(ALL('TableName'),'TableName'[Amount])

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

KPI visual would display blank without adding any field into "Trend axis". As a workaround, to set total number as target value in KPI, you could create a measure similar to below, add it into "Target goals":

total target = SUMX(ALL('TableName'),'TableName'[Amount])

Best regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    In this case what would you add to the Trend axis?