Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Highlight Current Week in a Matrix

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
 
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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