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,

 

The table Historique is:

 

JVWeekCategorieVolume
JVITjanv-26Between 3Y and 90D3,51E+12
JVFRjanv-26Between 3Y and 10Y3,19E+12
JVFRjanv-26Between 3Y and 90D3,18E+12
JVUKjanv-26Between 3Y and 90D1,65E+12
JVITjanv-26Between 3Y and 10Y1,55E+12
HQFRjanv-26Between 3Y and 90D1,37E+12
JVPLjanv-26Between 3Y and 90D1,17E+12
JVDEjanv-26Between 3Y and 90D9,05E+11
JVUKjanv-26Between 3Y and 10Y8,14E+11
JVITjanv-26Less than 90D7,62E+11
JVFRjanv-26Less than 90D7,42E+11
HQFRjanv-26Between 3Y and 10Y7,32E+11
JVNLjanv-26Between 3Y and 90D6,83E+11
JVBEjanv-26Between 3Y and 90D6,22E+11
JVAUjanv-26Between 3Y and 10Y5,77E+11
JVFRjanv-2610Y and more5,26E+11
JVPLjanv-26Between 3Y and 10Y4,85E+11
HQFRjanv-2610Y and more3,76E+11
JVBEjanv-26Between 3Y and 10Y3,76E+11
JVAUjanv-26Between 3Y and 90D3,47E+11
JVUKjanv-26Less than 90D2,75E+11
JVDEjanv-26Between 3Y and 10Y2,71E+11
JVAUjanv-2610Y and more2,20E+11
ASSUjanv-26Between 3Y and 90D1,71E+11
JVDEjanv-26Less than 90D1,69E+11
JVPLjanv-26Less than 90D1,65E+11
HQFRjanv-26Less than 90D1,65E+11
JVBEjanv-26Less than 90D1,60E+11
ASSUjanv-26Between 3Y and 10Y1,17E+11
JVPLjanv-2610Y and more1,12E+11
JVNLjanv-26Between 3Y and 10Y1,03E+11
JVITjanv-2610Y and more76996742060
JVAUjanv-26Less than 90D73581114642
ASSUjanv-26Less than 90D34920870358
JVNLjanv-26Less than 90D19587381952
JVPLfeb-26Less than 90D1,54E+11
HQFRfeb-26Less than 90D1,45E+11
JVESfeb-26Less than 90D1,33E+11
ASSUfeb-26Between 3Y and 10Y1,19E+11
JVPLfeb-2610Y and more1,12E+11
JVESfeb-26Between 3Y and 90D1,10E+11
JVNLfeb-26Between 3Y and 10Y1,09E+11
JVITfeb-2610Y and more76996775905
JVAUfeb-26Less than 90D60576955829
ASSUfeb-26Less than 90D34737386824
JVUKfeb-2610Y and more17182813778
JVNLfeb-26Less than 90D16185336043
JVDEfeb-2610Y and more11820054632
JVNLfeb-2610Y and more11818724777
JVBEfeb-2610Y and more7441209608
JVESfeb-26Between 3Y and 10Y5955133014
JVESfeb-2610Y and more18518367
JVFRfeb-26Between 3Y and 90D3,26E+12
JVFRfeb-26Between 3Y and 10Y3,24E+12
JVFRfeb-26Less than 90D6,72E+11
JVFRfeb-2610Y and more5,26E+11

 

The matrix:

 

The result:

-cell in red or green for the last month if upgrade/downgrade

- a colored arrow
I haven't a preference

Thanks

    • 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

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

    Hi FP68 ,

    Pleas try appoarch suggested by FBergamaschi 

    if it doesnt work, please try sample pbix attcahed.

     

    Please give kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

     

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

      Hi Praful_Potphode 

       

      Thanks for your solution.
      The only problem is that we see always the column Volumn Indicator and I just want the last one

       

       

      Regards

       

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

        HI FP68 ,

        Thats the behaviour of matrix visual.we have pulled months into columns and two measures in values.so for all the months it will show both measures.

         

        Thanks and Regards,

        Praful