display a column in RED color in Matrix with dynamic data

[Sejal]

Hello :

I have a report with matrix visual on it.

Data is dynamic which changes every Friday.

I want to display last date column in Red color. See attached pic. How to do it using Measure ? Thanks 

[Sejal]

In dynamic table , I haved created index and pivoted the column. then on report, I have used matrix .

on matrix, I have used...

Rows - Corporation ,

Columns - attribute - date , 

Value- sum of values. 

a column that has name "2023-03-03" is an attribute. 

I m using dynamic table. It takes last 10 weeks of data and displays it on matrix.

And column changes every Friday. so "2023-03-03" will be shifted  and we will get new column "2023-03-10" as last column and we want to display that column in red.

so Every Friday the last column changes and we want to display only the last column in RED.

[v-jingzhang]

Hi @Sejal 

Is [2023-03-03] a column that has name "2023-03-03" or it's just a value in a column? How do you generate the matrix visual currently? What is on row, column and values of the matrix? We need to know the field names and types before generating a measure for it. 

Best Regards,
Community Support Team _ Jing

[Sejal]

Hello  :

Did u find out the solution of this ?

I would really appreciate if u can let me know.

thx,

Sejal

[v-jingzhang]

Hi @Sejal 

Sorry for the late response. You can try a measure similar to below for conditional formatting. 

Color Measure = 
VAR _lastDate = CALCULATE(MAX('Table'[Date]),ALL('Table'))
RETURN
IF(SELECTEDVALUE('Table'[Date])=_lastDate,1,0)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Sejal]

Hi Jing:

Thanks for your reply.

It does the last column of report in color RED. We want 3rd last column in Red.

Please see the pic which I have inserted in the first post.

on Matrix, I am taking all columns from attribute which contains dates ,corporation and other columns . see attached pic.

So how do we get the column with latest date "2023-03-03" and make it color RED ? and latest date keeps changing every week.

 Please advise.