Forum Discussion

SaiJ301120's avatar
SaiJ301120
Frequent Visitor
3 years ago
Solved

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,d...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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))

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

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:

 

 

 

SaiJ301120's avatar
SaiJ301120
Frequent Visitor
3 years ago

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

    • SaiJ301120's avatar
      SaiJ301120
      Frequent Visitor
      3 years ago

      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

      MonthProjects DeliveredValueComments
      Sep-228120No issue
      Oct-229110NA
      Nov-22760No issue
      Dec-22770No issue 
      Jan-236100

      Data Breach Issue

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        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))