custom card to show actual value and variance

[Minakshi]

Kindly help me with a custom visual which can show value and variance with up or down arrow or green or red arrow to show actual value and variance.

Thanks in advanced

[v-yangliu-msft · Accepted solution]

Hi  @Minakshi ,

I created some data:

Custom rules:

Variance: the variance of January and February

Actual value: January and February as a percentage of the total value

Here are the steps you can follow：

1. Create measure.

variance% =
var _month_1=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),MONTH('Table'[date])=1))
var _month_2=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),MONTH('Table'[date])=2))
return
DIVIDE(_month_1-_month_2,_month_1)

actual value =
var _month_1=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),MONTH('Table'[date])=1))
var _month_2=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),MONTH('Table'[date])=2))
var _all=SUMX(ALL('Table'),'Table'[amount])
return
DIVIDE(_month_1+_month_2,_all)

2. Find the KPI chart, place [date] in Trend axis, place [actual value] in Target goals, and place [variance%] in Indicator

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[vanessafvg]

this video is useful in helping you to understand how to use the kpi card https://www.youtube.com/watch?v=zHzSBNES6jE