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.

lovishsood1's avatar
lovishsood1
Resolver I
4 years ago

Hi,

It looks like It's highlighting only selected fields but I need to highlight All the cells from Top to bottom.

As you can see, it only highlighted where data exists but I want to highlight all cells along with the Header. To show that Feb 5&6 are Weekends.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi lovishsood1 

 

It seems whether data (the value field) exists, there is some filter passing so it couldn't get the correct unique date when data doesn't exist (blank). I did a test, when I put a simple measure Value = 1 in Values, there is no blank data. So the color measures works well. You can see the following image. 

 

Unfortunately, I couldn't figure out how to set up the correct color when data is blank. Maybe the IF logic should be more complex but I have no idea currently.

 

In addition, conditional formatting feature is only applied to Values and Totals at present. It couldn't be applied to row headers and column headers. There are some similar ideas you can vote up:

Microsoft Idea - conditional formating for column header

Microsoft Idea - Conditional Formatting to Row/Column Headers

Microsoft Idea - Column Conditional Formatting in a Matrix

 

Best Regards,

Jing

  • lovishsood1's avatar
    lovishsood1
    Resolver I
    4 years ago

    Yeah, Thanks. I got that. We don't have any option to highlight Column Header where Weekends are there. Only Values are highlighted where Weekends exists.