Forum Discussion

FP68's avatar
FP68
Icon for Helper I rankHelper I
5 months ago

How to add an indicator

Hello, I’m trying to set an indicator on a Matrix. It is composed from a History table that has a column with the name of a site (JV), a month (Month) and a volume (VolumeGo) So i have one line pe...
FP68's avatar
FP68
Icon for Helper I rankHelper I
5 months ago

Hi FBergamaschi 

 

I'm sorry, I can't open your pbix. I've th emessgae:

Could you store it for an oldest version.
I use :

 

Thanks in advance

  • FBergamaschi's avatar
    FBergamaschi
    Icon for Super User rankSuper User
    5 months ago

    Hi FP68 

    I cannot do that, sorry.

    Anyway the measures I wrote are just two

     

    Volume = SUM ( Tabella[Volume] )

     

    Hightlight =
    VAR _CurrVolume = [Volume]
    VAR _PYVolume = CALCULATE ( [Volume], DATEADD ( 'Date'[Date], -1, MONTH ) )
    RETURN
    IF (
             _CurrVolume <> 0,
             IF (
                    _CurrVolume > _PYVolume,
                     IF ( _PYVolume > 0, "#00FF00" ),
                     IF ( _CurrVolume < _PYVolume, "#FF0000" )
            )
    )

     

    and then used the last measure for the background color as shown here

     

     

     

    Hope this helps to get a solution from my post

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI