Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
this video is useful in helping you to understand how to use the kpi card https://www.youtube.com/watch?v=zHzSBNES6jE
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |