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?

  • 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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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

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