How to add an indicator

[FP68]

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 per month for each site.
I want it to be indicated for the last 2 known months if the volume has increased or not. We can very well say that the last known month is the current month -1
I tried with a calculated column but I can’t manage
Thank you for your help

[v-tejrama]

Hi @FP68 ,

Thank you @Kedar_Pande  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.

[v-tejrama]

Hi @FP68 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[FP68]

Hi ,
For the moment I haven't a solution.
Regards

[v-tejrama]

Hi @FP68 ,

I wanted to check if you had the opportunity to review the information provided by @Kedar_Pande  Please feel free to contact us if you have any further questions related to it .

Thank you.

[v-tejrama]

Hi @FP68 ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[Kedar_Pande]

Add Month Offset calculated column:

Month Offset = DATEDIFF(TODAY(), History[Month], MONTH)

Measure for indicator:

 

Trend Indicator = 
VAR CurrentVol = [VolumeGo]
VAR PrevVol = 
CALCULATE(
[VolumeGo],
FILTER(History, History[Month Offset] = MAX(History[Month Offset]) + 1)
)
RETURN 
IF(CurrentVol > PrevVol, "↑", IF(CurrentVol < PrevVol, "↓", "→"))

[FP68]

Hi,

The table Historique is:

JV	Week	Categorie	Volume
JVIT	janv-26	Between 3Y and 90D	3,51E+12
JVFR	janv-26	Between 3Y and 10Y	3,19E+12
JVFR	janv-26	Between 3Y and 90D	3,18E+12
JVUK	janv-26	Between 3Y and 90D	1,65E+12
JVIT	janv-26	Between 3Y and 10Y	1,55E+12
HQFR	janv-26	Between 3Y and 90D	1,37E+12
JVPL	janv-26	Between 3Y and 90D	1,17E+12
JVDE	janv-26	Between 3Y and 90D	9,05E+11
JVUK	janv-26	Between 3Y and 10Y	8,14E+11
JVIT	janv-26	Less than 90D	7,62E+11
JVFR	janv-26	Less than 90D	7,42E+11
HQFR	janv-26	Between 3Y and 10Y	7,32E+11
JVNL	janv-26	Between 3Y and 90D	6,83E+11
JVBE	janv-26	Between 3Y and 90D	6,22E+11
JVAU	janv-26	Between 3Y and 10Y	5,77E+11
JVFR	janv-26	10Y and more	5,26E+11
JVPL	janv-26	Between 3Y and 10Y	4,85E+11
HQFR	janv-26	10Y and more	3,76E+11
JVBE	janv-26	Between 3Y and 10Y	3,76E+11
JVAU	janv-26	Between 3Y and 90D	3,47E+11
JVUK	janv-26	Less than 90D	2,75E+11
JVDE	janv-26	Between 3Y and 10Y	2,71E+11
JVAU	janv-26	10Y and more	2,20E+11
ASSU	janv-26	Between 3Y and 90D	1,71E+11
JVDE	janv-26	Less than 90D	1,69E+11
JVPL	janv-26	Less than 90D	1,65E+11
HQFR	janv-26	Less than 90D	1,65E+11
JVBE	janv-26	Less than 90D	1,60E+11
ASSU	janv-26	Between 3Y and 10Y	1,17E+11
JVPL	janv-26	10Y and more	1,12E+11
JVNL	janv-26	Between 3Y and 10Y	1,03E+11
JVIT	janv-26	10Y and more	76996742060
JVAU	janv-26	Less than 90D	73581114642
ASSU	janv-26	Less than 90D	34920870358
JVNL	janv-26	Less than 90D	19587381952
JVPL	feb-26	Less than 90D	1,54E+11
HQFR	feb-26	Less than 90D	1,45E+11
JVES	feb-26	Less than 90D	1,33E+11
ASSU	feb-26	Between 3Y and 10Y	1,19E+11
JVPL	feb-26	10Y and more	1,12E+11
JVES	feb-26	Between 3Y and 90D	1,10E+11
JVNL	feb-26	Between 3Y and 10Y	1,09E+11
JVIT	feb-26	10Y and more	76996775905
JVAU	feb-26	Less than 90D	60576955829
ASSU	feb-26	Less than 90D	34737386824
JVUK	feb-26	10Y and more	17182813778
JVNL	feb-26	Less than 90D	16185336043
JVDE	feb-26	10Y and more	11820054632
JVNL	feb-26	10Y and more	11818724777
JVBE	feb-26	10Y and more	7441209608
JVES	feb-26	Between 3Y and 10Y	5955133014
JVES	feb-26	10Y and more	18518367
JVFR	feb-26	Between 3Y and 90D	3,26E+12
JVFR	feb-26	Between 3Y and 10Y	3,24E+12
JVFR	feb-26	Less than 90D	6,72E+11
JVFR	feb-26	10Y and more	5,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]

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]

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]

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

[FBergamaschi]

Hi @FP68,

how abou this?

File attached

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

[FP68]

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]

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

[FBergamaschi]

Hi @FP68, 

please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Alternatively, you can share your .pbix via some cloud service and paste the link here. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

Need help uploading data? click here

Want faster answers? click here