Forum Discussion

lovishsood1's avatar
lovishsood1
Resolver I
4 years ago
Solved

Highlight Weekends on Matrix Visual

Hey!  I have one Matrix Visual as :  Column Header: Date Table (Calendar) Row Header: Table 1 Values: Table 2(Calculated Column)   I have applied Conditional Formatting on Values (Background co...
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi lovishsood1 

     

    Try using this measure for conditional formatting instead. I put your ValuesColor column in it. 

    ColorMeasure =
IF (
    WEEKDAY ( SELECTEDVALUE ( 'Date'[Date] ), 2 ) >= 6,
    "Green",
    SELECTEDVALUE ( 'Table 2'[ValuesColor] )
)

     

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

amitchandak's avatar
amitchandak
Super User
4 years ago

lovishsood1 , You can create a color measure or can merge this code with another color measure 

 

Switch(True() ,

Weekday(max('Date'[Date]),2) >=6, "Yellow",

"Green"

)

 

Use this in conditional formatting using field value option

  • lovishsood1's avatar
    lovishsood1
    Resolver I
    4 years ago

    I have Calculated Column of colors  in Table 2 so I'm not able to fetch the Date Table there.