Forum Discussion
Displaying Change Indicators
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))
This is the sample data , what i wanted to do is display is both dec and jan values and have an indicator displayed with the difference indication if project delivery has increased or decreased .i do not need the difference to be displayed just the indicator should be enough
| Month | Projects Delivered | Value | Comments |
| Sep-22 | 8 | 120 | No issue |
| Oct-22 | 9 | 110 | NA |
| Nov-22 | 7 | 60 | No issue |
| Dec-22 | 7 | 70 | No issue |
| Jan-23 | 6 | 100 | Data Breach Issue |
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))Hey FreemanZ Thanks Heaps for all the support you have provided , i was able to crack the requirement and it is now working good .
This can work but i want to display only the last two months that too in a format like two individual visuals for the previous and previous of previous (Just those two) and and an indicator for which i suppose we can use a card with unichar values for indications .
one like the picture i have provided in the doubt above
Thanks for all the Effort .