Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Advanced Card / KPI

Hi, are there any method for showing the callout value by using the distance to goal value (the percentage only) instead of the original value.  Something like third image. Also, are there any method...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    I think you could create a measure to calculate the percent. then add card visual.

    1, create a measure,

    %trend = SUM([actual])/SUM([target])-1

    2.add card visual.

    3. conditional color about value.

    condition = IF([%trend]>0.05,"#D64550",IF([%trend]<0,"green","black"))

    The final show:


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

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

I think you could create a measure to calculate the percent. then add card visual.

1, create a measure,

%trend = SUM([actual])/SUM([target])-1

2.add card visual.

3. conditional color about value.

condition = IF([%trend]>0.05,"#D64550",IF([%trend]<0,"green","black"))

The final show:


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