Highlight fields in pivot table

[alekpprrr]

Hi, all!

How can I highlight cells that are weekends? I need to distinguish those values

Thanks!

[rubenmarin]

Hi, if the dimensions are related to month and day number, you can ad a field in script that uses those values to check the date, and if that date was on weekend.

To check if it was on weekend you can use weekday() function

If(WeekDay(DateValue)>=5,1,0) as isWeekend

With that field you only need to add a color expression to the table as: If(isWeekend, Yellow())