Reply
Member
Posts: 108
Registered: ‎09-13-2017
Accepted Solution

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?


Accepted Solutions
Community Support Team
Posts: 5,684
Registered: ‎09-21-2016

Re: KPI visual without trend

Hi @wieke,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 5,684
Registered: ‎09-21-2016

Re: KPI visual without trend

Hi @wieke,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.