Forum Discussion
Anonymous
8 years agoNot applicable
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-msftMicrosoft 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
- AnonymousNot applicable
In this case what would you add to the Trend axis?