cancel
Showing results for
Did you mean:  Resolver I

custom card to show actual value and variance

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.

1 ACCEPTED SOLUTION  Community Support

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

2 REPLIES 2  Community Support

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  Super User

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!   