Forum Discussion
Displaying Change Indicators
I Have a requirement to show the previous month value and previous of previous month value in individually and betwwen these two to have an arrow indication if the present month value has increased,decreased or same when compared with the previous month .
Are there any specific visuals which can help me in this regard or if there are any workaround with the exisiting visuals . the values are currently represented in the card visual but arrows indications i cant figure out how to put them .
SOmething like this
Any Help is Appreciated !
hi SaiJ301120
something like this?
Indicator = VAR _valuecurrent = SUM(TableName[Projects Delivered]) VAR _valuecurrentlm = SUMX( FILTER( ALL(TableName), TableName[Date]=EDATE(MAX(TableName[Date]), -1) ), TableName[Projects Delivered] ) VAR _diff = _valuecurrent - _valuecurrentlm RETURN IF( _diff>=0, UNICHAR(9650), UNICHAR(9660))
7 Replies
hi SaiJ301120
it is achievable with the standard card visual.
try to feed the measure with a measure like:
Measure = VAR _value = 0.2 //replace 0.2 with others, like a measure VAR _pct = FORMAT(_value, "0.0%") RETURN IF(_value >0, _pct & UNICHAR(9650), _pct & UNICHAR(9660))it worked like:
Hey Freeman , Thanks for answering my quesion but can you elaborate on this please i can provide you with the sample data if needed .
what i precisely need is as per the picture i have provided and giving me the measure defintions would be more helpful .
Thanks
