Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 12 | |
| 10 | |
| 8 |