Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.