Forum Discussion
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 color) via Field Value Formatting Style.
Now, I also want to highlight Weekends
As you can see 15 and 16 January are Sat & Sun. So I want to highlight them with another color but as Conditional Formatting is already applied on Values 15&16 Jan are getting highlighted with given colors.
In Conditional Formatting , I have set this for BG Colors :
ValuesColor = SWITCH(TRUE(),
_Table2[_Total]=" ","Yellow",
_Table2[_Total]="AM","Purple",
_Table2[_Total]="PM","Purple"
)
How I can highlight Weekends on Columns Headers and Values as well with a specific Color?
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.
6 Replies
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
I have Calculated Column of colors in Table 2 so I'm not able to fetch the Date Table there.
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.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.
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
