Highlight Current Week in a Matrix

[Anonymous]

Hi All

I tried to highlight the current row in a Matrix using Conditional Formatting Rule based on

WeekRowFormat =

VAR Wk = SELECTEDVALUE( DimDate[Week])

RETURN

IF( FORMAT( Today(), "YYYYWW") = Wk, 1)

The values in my Matrix for Week look like

202201

202202

202203

etc

Any ideas why the above doesn't work and how I can fix it? If at all

[amitchandak · Accepted solution]

@Anonymous , Create measure like

IF( FORMAT( Today(), "YYYYWW") = max( DimDate[Week]), "Green", "White")

use that in conditional formatting using field value option

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4