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(), "YY...
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

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