Forum Discussion

FP68's avatar
FP68
Icon for Helper I rankHelper I
6 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
6 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

Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
6 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
    6 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
      6 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