DAX to color the font into red or cell into red for weekends in Table Matrix visualization

deb_power123 — Wed, 14 Apr 2021 08:18:21 GMT

Hi All,

I want to color the font or the cell containing the weekends[ Saturday and Sunday] into red in table matrix. Is that possible ? Can we handle it using DAX? Please suggest

My sample input data is as below :-

Date	TotalSeats	OccupiedSeats	School Name	Buildings
21-03-2021	10	1	School1	Building1
22-03-2021	10	4	School1	Building1
23-03-2021	10	4	School1	Building1
24-03-2021	10	1	School1	Building1
25-03-2021	10	2	School1	Building1
26-03-2021	10	1	School1	Building1
27-03-2021	10	1	School1	Building1
21-03-2021	12	5	School1	Building2
22-03-2021	12	8	School1	Building2
23-03-2021	12	8	School1	Building2
24-03-2021	12	3	School1	Building2
25-03-2021	12	4	School1	Building2
26-03-2021	12	2	School1	Building2
27-03-2021	12	4	School1	Building2

Expected Output: it should either color the cell containing weekend[Saturday and Sunday dynamically] as red or it should color its font as red.

Re: DAX to color the font into red or cell into red for weekends in Table Matrix visualization

amitchandak — Wed, 14 Apr 2021 17:34:36 GMT

deb_power123 , In matrix you cam can not color values in row and columns

topic Re: DAX to color the font into red or cell into red for weekends in Table Matrix visualization in DAX Commands and Tips

DAX to color the font into red or cell into red for weekends in Table Matrix visualization

Re: DAX to color the font into red or cell into red for weekends in Table Matrix visualization